| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"000" + number + "."
One way
=TEXT(A2,"000000.") -- Regards, Peo Sjoblom http://nwexcelsolutions.com "0-0 Wai Wai ^-^" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"000" + number + "."
=TEXT(A1,"000000")&"."
-- Kind regards, Niek Otten "0-0 Wai Wai ^-^" wrote in message ... | | 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 | | |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"000" + number + "."
"Niek Otten" ¦b¶l¥ó ¤¤¼¶¼g... =TEXT(A1,"000000")&"." Excellent! The 000000 works like a charm! Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"000" + number + "."
Thanks for your help!
|
| Reply |
| 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) | |||
Linear Mode
