numerical data sort

B

brichwine

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.
 
D

Duke Carey

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
 
M

Morrigan

brichwine said:
Recently, my Excel 2000 starting sorting numbers differently. It no
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 t
make it sort correctly? Thank you.
Click to expand...



Try this:

Select the data -> Date -> Text to Columns -> Finish

Now sort them
 
M

Morrigan

brichwine said:
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.
Click to expand...



Try this:

Select the data -> Date -> Text to Columns -> Finish

Now sort them.
 
M

Morrigan

brichwine said:
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.
Click to expand...



Try this:

Select the data -> Date -> Text to Columns -> Finish

Now sort them.
 
M

Morrigan

brichwine said:
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.
Click to expand...



Try this:

Select the data -> Date -> Text to Columns -> Finish

Now sort them.
 
Top