You may need to make your file (or a shrinky-dink version of it) available
at a free file-hosting service and post the link here. That way we'll be
able to see what your describing.
Here are some options:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php
-------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"lifeworksla" wrote in message
...
I did that, it still doesn't sort the first three columns.
"Gord Dibben" wrote:
Don't let Excel guess.
Select all the columns in your data range before sorting on the address
column.
Gord Dibben MS Excel MVP