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

"Texas Nuckols" wrote:

I need this list of numbers to sort numerically
1
1001
1015
102
1045
105
1053
Why is it sorting like this?

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 cellMark your block of "numbers"Paste SpecialMultiply

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

--
Regards
Roger Govier

"Texas Nuckols" wrote in message
...
I need this list of numbers to sort numerically
1
1001
1015
102
1045
105
1053
Why is it sorting like this?