Excel will do that if your numbers are entered as text. To force them to be
numbers, copy an empty cell, select all the numbers, and use Edit-Paste
Special-Values-Add.
Once you do that the numbers will sort the way you expect & intend
Duke
"brichwine" wrote:
Recently, my Excel 2000 starting sorting numbers differently. It now
sorts numbers like this: 116, 1228, 1264, 130 - instead of 116, 130,
1228, 1264. Does anyone know how to reset this or change an option to
make it sort correctly? Thank you.
--
brichwine
------------------------------------------------------------------------
brichwine's Profile: http://www.excelforum.com/member.php...o&userid=31419
View this thread: http://www.excelforum.com/showthread...hreadid=511133