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.
Try this:
Select the data - Date - Text to Columns - Finish
Now sort them.
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=511133