Format cell so zeros don't dissappear?

[Neenah]

Everytime I enter "000123456" and tab to next cell the zeros disappear....I
need the zeros to remain in the cell???

Help

[Chip Pearson]

Use a custom number format of 000000000. Go to the Format menu,
choose Cells, then in that dialog the Number tab. There choose
Custom from the list and enter 000000000.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Neenah" <[email protected]> wrote in message
news:[email protected]...
> Everytime I enter "000123456" and tab to next cell the zeros
> disappear....I
> need the zeros to remain in the cell???
>
> Help

[Anne Troy]

You need "leading zeroes" formatting, Neenah. Try these tips:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Neenah" <[email protected]> wrote in message
news:[email protected]...
> Everytime I enter "000123456" and tab to next cell the zeros
> disappear....I
> need the zeros to remain in the cell???
>
> Help

[Boethius1]

You have to prefix with an apostrophe, enter '000123456

However this is a real pain, does anyone know a way to format the cell?

--------------

Everytime I enter "000123456" and tab to next cell the zeros disappear....I
need the zeros to remain in the cell???

Help

[Neenah]

Thank you for the help.....I have been pulling my hair out...


"Chip Pearson" wrote:

> Use a custom number format of 000000000. Go to the Format menu,
> choose Cells, then in that dialog the Number tab. There choose
> Custom from the list and enter 000000000.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Neenah" <[email protected]> wrote in message
> news:[email protected]...
> > Everytime I enter "000123456" and tab to next cell the zeros
> > disappear....I
> > need the zeros to remain in the cell???
> >
> > Help
>
>
>