|
Posted to microsoft.public.excel.misc
|
|
|
sorting IP addresses
See:
http://www.microsoft.com/office/comm...cb6&sloc=en-us
--
Gary''s Student
"PattiTechWriter" wrote:
I have a range of IP Addresses (xx.xx.xxx.1 through .255). When I sort by
this column, I get xx.xx.xxx.0 through .99 followed by xx.xx.xxx.1 through
.199 and then 2 - 255. Is there a way to force it so that it sorts in a
sequencial 1,2,3,4... order?
|