PTW,
My Excel add-in Special Sort will do that along with more than 20 other
sorts not readily available in Excel.
Looks and works something like the built in sort utility.
Comes with a Word.doc install/use file.
It is available for - free - email me and ask for it.
Remove XXX from my email address.
Jim Cone
San Francisco, USA
XX


"PattiTechWriter"
wrote in message
...
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?