Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding numbers or characters to existing numbers | Excel Worksheet Functions | |||
How do I retain leading zeros in a column of numbers when file op | Excel Discussion (Misc queries) | |||
prefix a column of numbers with combination of zeros | Excel Discussion (Misc queries) | |||
how do i make a list of consecutive numbers in a column? | Excel Worksheet Functions | |||
How to add a 1 to existing column of phone numbers? | Excel Discussion (Misc queries) |