how do i insert a leading zero in excel

September 26, 2010 at 12:24:15
Specs: Windows XP
how do,i insert leading zero's for a column of numbers in excel

See More: how do i insert a leading zero in excel

Report •

#1
September 26, 2010 at 15:48:45
You have to use a Custom Format.
If it's a five digit number then custom format as 00000
more numbers, more zeros in the Custom Format

MIKE

http://www.skeptic.com/


Report •

#2
September 26, 2010 at 16:16:15
...or format it as Text by using a single quote.

It all depends on what you are using the numbers for.

With '01000 in A1 and A2, =A1 + A2 will return 2000, however =SUM(A1:A2) will return 0.

Isn't Excel fun?


Report •

#3
September 26, 2010 at 17:11:53
And just to make life a bit more interesting,.....

If you always want a leading zero for your number,
regardless of what you enter, IE

you enter 1234 you get 01234

then a custom format of: "0"#
will always insert a zero before your number.
if you always want two leading zeros, "00"#

Always good to know what you want before you start......

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question