How to displaly a number beginning with a zero

[Lisa]

How do I enter a number that begins with zero and have it
display correctly i.e. 0123?

Thx
Lisa

[Sir_George]

Lisa,

What program are you using? Generally, you can accomplish this by placing a
decimal point in front of the number or in most programs you can format the
cell as text and it will work.

--
Sir_George


"Lisa" > wrote in message
...
> How do I enter a number that begins with zero and have it
> display correctly i.e. 0123?
>
> Thx
> Lisa

[Mike Mulligan]

Look here:

http://support.microsoft.com/newsgroups/default.aspx?newsgroup=microsoft.public.excel.newu sers&SCLID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups

Mike Mulligan

"Lisa" > wrote in message
...
> How do I enter a number that begins with zero and have it
> display correctly i.e. 0123?
>
> Thx
> Lisa

[Lisa]

Thank you Mike.
>-----Original Message-----
>Look here:
>
>http://support.microsoft.com/newsgroups/default.aspx?
newsgroup=microsoft.public.excel.newusers&SCLID=US&ICP=GSS
3&sd=GN&id=fh;en-us;newsgroups
>
>Mike Mulligan
>
>"Lisa" > wrote in message
...
>> How do I enter a number that begins with zero and have
it
>> display correctly i.e. 0123?
>>
>> Thx
>> Lisa
>
>.
>

[Lisa]

Excel. However, it must be entered as a value and not
text for calculation purposes.
Thx
Lisa
>-----Original Message-----
>Lisa,
>
>What program are you using? Generally, you can
accomplish this by placing a
>decimal point in front of the number or in most programs
you can format the
>cell as text and it will work.
>
>--
>Sir_George
>
>
>"Lisa" > wrote in message
...
>> How do I enter a number that begins with zero and have
it
>> display correctly i.e. 0123?
>>
>> Thx
>> Lisa
>
>
>.
>

[Sir_George]

Lisa,

There is no whole number that begins with 0, other than 0 (which is
sometimes questionable). See the following site;
http://mathworld.wolfram.com/WholeNumber.html

Therefore, I don't believe you will be able to convince Excel that it should
change behavior and go against true mathematic principles.

--
Sir_George


"Lisa" > wrote in message
...
> Excel. However, it must be entered as a value and not
> text for calculation purposes.
> Thx
> Lisa
> >-----Original Message-----
> >Lisa,
> >
> >What program are you using? Generally, you can
> accomplish this by placing a
> >decimal point in front of the number or in most programs
> you can format the
> >cell as text and it will work.
> >
> >--
> >Sir_George
> >
> >
> >"Lisa" > wrote in message
> ...
> >> How do I enter a number that begins with zero and have
> it
> >> display correctly i.e. 0123?
> >>
> >> Thx
> >> Lisa
> >
> >
> >.
> >