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

[Guest]

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.

 

[Beege]

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.

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

 

[Guest]

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.