Sorting Numbers

  • Thread starter Thread starter Texas Nuckols
  • Start date Start date
T

Texas Nuckols

I need this list of numbers to sort numerically
1
1001
1015
102
1045
105
1053
Why is it sorting like this?
 
The cells are formatted as text or the data has an apostrophe before it to
signify text. Either remove the apostrophies or format the cells as numbers
 
Hi

The numbers must have been entered (or copied) as text values, not numbers.
place a number 1 in a blank cell somewhere on your sheet.
Copy that cell>Mark your block of "numbers">Paste Special>Multiply

That should convert them to true numeric's and the sort will work as you
expect in increasing numerical value.
 
Back
Top