How do I create a leading zero in a number field, (i.e. 0301234)?

J

Jim Clay

I have numbers that need to be added to my spreadsheet that contain a leading
zero, same as the subject. It is part of the number, some also have 1s or 2s
so the zero is an imporatant part of the number.
 
B

Beege

Jim said:
I have numbers that need to be added to my spreadsheet that contain a leading
zero, same as the subject. It is part of the number, some also have 1s or 2s
so the zero is an imporatant part of the number.
Click to expand...

Jim,

If your number is NOT calculated, i.e. a part number, then format the
cells as text.

If it IS calculated and you have a standard length (say 8 places), then
format/special/00000000

k?

Beege
 
T

toni.gee

Assuming that all the numbers contain the same number of digits (say, 7 in
your example), set the cell number format to 0000000 (via the Format - Cells
- Number - Custom option). Any numbers entered upto 7 digits in length will
be padded with leading zeros to make it 7 digits long.
 
Top