software

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

Help

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.comquot;Neenahquot; gt; wrote in message
...
gt; Everytime I enter quot;000123456quot; and tab to next cell the zeros
gt; disappear....I
gt; need the zeros to remain in the cell???
gt;
gt; Help
You need quot;leading zeroesquot; formatting, Neenah. Try these tips:
www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Neenahquot; gt; wrote in message
...
gt; Everytime I enter quot;000123456quot; and tab to next cell the zeros
gt; disappear....I
gt; need the zeros to remain in the cell???
gt;
gt; Help

You have to prefix with an apostrophe, enter '000123456

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

--------------Neenah Wrote:
gt; Everytime I enter quot;000123456quot; and tab to next cell the zeros
gt; disappear....I
gt; need the zeros to remain in the cell???
gt;
gt; Help--
Boethius1------------------------------------------------------------------------
Boethius1's Profile: www.excelforum.com/member.php...oamp;userid=30497
View this thread: www.excelforum.com/showthread...hreadid=502651Thank you for the help.....I have been pulling my hair out...quot;Chip Pearsonquot; wrote:

gt; Use a custom number format of 000000000. Go to the Format menu,
gt; choose Cells, then in that dialog the Number tab. There choose
gt; Custom from the list and enter 000000000.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Neenahquot; gt; wrote in message
gt; ...
gt; gt; Everytime I enter quot;000123456quot; and tab to next cell the zeros
gt; gt; disappear....I
gt; gt; need the zeros to remain in the cell???
gt; gt;
gt; gt; Help
gt;
gt;
gt;