number digits 1-6 not sorting properly

  • Thread starter Thread starter m
  • Start date Start date
M

m

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.
 
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 Edit>Paste Special>Add>OK>Esc

They should now sort as numbers.


Gord Dibben MS Excel MVP
 
Back
Top