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

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

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

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

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

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