| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting IP Addresses in Excel?
I'm trying to sort IP addresses in Excel, but I can't seem to either adjust
(custom format) the numbers to end in three digits to get it to sort properly. For example, if I sort as-is, I get: 192.103.179.1 192.103.179.10 192.103.179.100 192.103.179.11 192.103.179.110 192.103.179.12 What I'd like to get is: 192.103.179.1 (or .001) 192.103.179.10 (or .010) 192.103.179.11 (or .011) 192.103.179.12 (or .012) 192.103.179.100 192.103.179.110 Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Sorting Columns on HTML file created in Excel | Excel Discussion (Misc queries) | |||
| Exporting addresses from excel to outlook | Excel Discussion (Misc queries) | |||
| Does font color affect sorting a list in Excel? | Excel Worksheet Functions | |||
| copy addresses from word to excel | Excel Worksheet Functions | |||
Threaded Mode
