| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Conversion
Hello
I currently have a worksheet with numbers that are formatted like IP Address (XXX.XXX.XXX.XXX) My problem is that some of the leading 0's are missing, for example 10.4.100.200 should be 010.004.100.200 Is there any quick way to convert the list so that it fits the format XXX.XXX.XXX.XXX, with any missing numbers being filled with 0's. Regards Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Number conversion | New Users to Excel | |||
| Number conversion to Hours | Excel Worksheet Functions | |||
| Number Conversion | Excel Discussion (Misc queries) | |||
| Number Conversion | Excel Discussion (Misc queries) | |||
| Number conversion | Excel Discussion (Misc queries) | |||
Threaded Mode
