how do,i insert leading zero's for a column of numbers in excel

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 FormatMIKE

...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?

And just to make life a bit more interesting,..... If you

alwayswant a leading zero for your number,

regardless of what you enter, IEyou 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

Ask Your Question

Weekly Poll

Do you think Samsung's Bixby will compete well against other phone AI systems?

Discuss in The Lounge

Poll History