numerical data sort
 

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

numerical data sort
 

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

numerical data sort
 

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

numerical data sort
 

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

numerical data sort
 

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

numerical data sort
 

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