G Guest Nov 15, 2004 #1 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?
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?
D Dave Peterson Nov 15, 2004 #2 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)
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)
G Guest Nov 15, 2004 #3 Thank you Dave, your a lifesaver! Dave Peterson said: 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) Click to expand...
Thank you Dave, your a lifesaver! Dave Peterson said: 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) Click to expand...
