numerical data sort

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

[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

"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
>
>

[Morrigan]

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]

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.

[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

"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
>
>