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:


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.