Need to pad with Zeros to the existing list of numbers in a column
 

I have some values in a spreadsheet and I would like to pad with zeros to the
right side. For Ex. 1224 should be converted as 01234

Need to pad with Zeros to the existing list of numbers in a column
 

Format the number as Category: Custom and Type: 00000

It won't change the number, just the way it is displayed

Regards

Trevor


"dwaraka" wrote in message
...
I have some values in a spreadsheet and I would like to pad with zeros to
the
right side. For Ex. 1224 should be converted as 01234