Probably one of the $48 is actually a number and the other, although it
looks like a number is actually TEXT....try copying the good $48 that sorted
properly and pasteing it over the bad $48 that did not sort properly and
sort again.....

Vaya con Dios,
Chuck, CABGx3


"StevenH" wrote in
message ...

I have a number of worksheets on three different computers in which the
sorting ends up flawed. So most cells will be right, but it might go
$50, $49, $48, $49, $47, $46, $48 etc. Is there a mistake I am likely
making to produce these results, a way that would help to fix this, or
something I should check with the cells to see what the problem might
be. Is this a common problem?


--
StevenH
------------------------------------------------------------------------
StevenH's Profile:
http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892