I am trying to put a serial number in a cell but it starts with a zero.
After I type in 09867453 and move to the next cell the 0 disappears.

Scott

You can format the cell to be text and it will then allow a 0 to be
added to the front of a number however this may cause problems if you
are using that number in inequalities.



Scottrow wrote:
> I am trying to put a serial number in a cell but it starts with a zero.
> After I type in 09867453 and move to the next cell the 0 disappears.
>
> Scott

Scott,

The first answer is correct however it may be alot easier if you add an
apostrophe ' before the number. It won't show it is excel's way of
letting you start cells with a 0.

On Nov 22, 9:36 am, "Scottrow" <mistersalsaREM...@comcast.net> wrote:
> I am trying to put a serial number in a cell but it starts with a zero.
> After I type in 09867453 and move to the next cell the 0 disappears.
>
> Scott

another way is to format>cutom format>00000000000 as many as you like to 15

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Scottrow" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am trying to put a serial number in a cell but it starts with a zero.
>After I type in 09867453 and move to the next cell the 0 disappears.
>
> Scott
>

"Don Guillett" <(E-Mail Removed)> wrote

> another way is to format>cutom format>00000000000 as many as you like to
> 15

That's the one I like because it data is still a number and can be
manipulated as such.

--
Bob
http://www.kanyak.com

glad to help

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Opinicus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Don Guillett" <(E-Mail Removed)> wrote
>
>> another way is to format>cutom format>00000000000 as many as you like to
>> 15
>
> That's the one I like because it data is still a number and can be
> manipulated as such.
>
> --
> Bob
> http://www.kanyak.com
>