MrExcel Publishing
Your One Stop for Excel Tips & Solutions

simple sort


Posted by jdenhoed on September 04, 2001 9:00 AM

I'm trying to sort a column of numbers, but am getting this effect:

1105
1106
1107
11075
11076
1108
1109
1110

Seems like I've wrestled with this before, but cannot remember the solution.

Thanks for any help you can give.


Posted by Mark W. on September 04, 2001 9:08 AM

You're sorting text representation of numbers.
Perhaps, these numbers were entered into cells
that were formatted as Text or the were entered
with an apostrophe (') prefix. To get 11075 and
11076 to the bottom of the list you'll need to
convert these text values to numbers. I
recommend that you Copy these values and then
using the Paste Special... Values Add option
paste them to another range of empty cells.

Posted by Barry Katcher on September 04, 2001 9:56 AM

Or, you can sort them even if they are text, but you have to remember to use leading zeros. If, say, you are using up to 5 digits (up to 99,000), all 4-digit "numbers" have to have one leading zero, every 3-digit "number" have to have two leading zeros, etc.