I need to have the number show as 00000001 but the 0 will not sta.

[Janet]

I need my number to have the prefix 0's left in place. Is there something I
need to turn off to get the 0's to show before a number?

 

[Dave Peterson]

If you can treat the value as text, just precede your entry with an apostrophe:

'0000123

If you want to have a numeric value in that cell, just type it normally, but
format the cell to show the leading 0's:

Format|Cells|number tab|custom category
Type: 0000000
(as many leading 0's as you need)

 

[Janet]

Thank you Dave, your a lifesaver!

If you can treat the value as text, just precede your entry with an apostrophe:

'0000123

If you want to have a numeric value in that cell, just type it normally, but
format the cell to show the leading 0's:

Format|Cells|number tab|custom category
Type: 0000000
(as many leading 0's as you need)