M
MrA
How do I get a leading 0 (zero) in Excell (2003)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Bundy
Several ways to go about it but I use text, note this will change the numbers
to text, replace "000" with total number of digits
=Text(A1,"000")
to text, replace "000" with total number of digits
=Text(A1,"000")
M
Mike
format the cell as text, you can still perform math functions on the number
D
David Biddulph
=0&A1, or look at the other replies.
S
SteveW
If you want a leading zero, so that all numbers have
a fixed size
use Custom Format 00000 or however many digits you want
Steve
a fixed size
use Custom Format 00000 or however many digits you want
Steve