Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"000" + number + "."
Hi. Here's the number list. 5 203 3450 4498 12358 This time, I need add extra "0" to the number until it has 6 digits & a dot at the end of the number, eg: 5 -- 000005. 203 -- 000203. How to do? Thank you! -- Additional info about my computer: - Office XP - Windows XP Pro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |