i have a simple sheet that basically consists of

name, ip address, and then other columns

obviously when i sort by ip address the .1,.2,.3,.4,.5, etc get sorted
in between the higher numbers ie:

.99
.100
.1
.101
.102

and i have to manually move them

i cant seem to see how you can sort within a column

if the above makes sense :)


--
adetorry
------------------------------------------------------------------------
adetorry's Profile: http://www.excelforum.com/member.php...o&userid=29151
View this thread: http://www.excelforum.com/showthread...hreadid=488723