I have a list w/ numbers, dates and description; attempting to sort the list
in number order but it is not recognizing the difference between e.g., 1400
and 14000 or 1623 and 16233 so it's sorty them together. Any help would be
appreciated. I've changed the format to number, text but still not correct
results.

Sounds like you need to force the cells to number type.

Enter 1 in a blank cell and copy the cell.

Highlight your set of numbers, paste special/multiply.

This will force them to number, and should allow a correct sort.

"m" wrote:

I have a list w/ numbers, dates and description; attempting to sort the list
in number order but it is not recognizing the difference between e.g., 1400
and 14000 or 1623 and 16233 so it's sorty them together. Any help would be
appreciated. I've changed the format to number, text but still not correct
results.

Changing the format is not sufficient if Excel sees your numbers as text.

You must coerce Excel to see them as numbers.

Format all to General.

Copy a blank cell.

Select the range to change and EditPaste SpecialAddOKEsc

They should now sort as numbers.


Gord Dibben MS Excel MVP

On Thu, 24 Sep 2009 12:41:01 -0700, m wrote:

I have a list w/ numbers, dates and description; attempting to sort the list
in number order but it is not recognizing the difference between e.g., 1400
and 14000 or 1623 and 16233 so it's sorty them together. Any help would be
appreciated. I've changed the format to number, text but still not correct
results.