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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort data 2
Queries to reduce a set of data pairs 3
Sorting with empty cells 5
Sorting rows of data of varying lengths 12
Identifying missing numerical values in a series 6
linking within a workbook and sorting 2
Sort by numbers problem 4
Sorting by number of characters 2

Back
Top