| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple conversion
I have a column of numbers such as:
030-000 033-020 033-030 123-456 I would like to convert these numbers to: 030.000 033.020 033.030 123.456 What is the best way to accomplish this? I would like to keep six digits even if the number begins with "0" or ends with "000". Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
Threaded Mode
