View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default 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