|Subject:||Re: sorting numbers in a column|
|Posted by:||John Wilson (jwils…@optonline.net)|
|Date:||Mon, 6 Oct 2003|
You have the numbers formatted as text (which is why you're getting
Format the numbers as General or Number (and remove any
apostrophies you might have before the numbers).
"Melissa" <melissahurl…@aol.com> wrote in message
> I am trying to sort numbers in a column, in numerical
> order. Instead, everytime I sort I get all of the 1's
> first, then the 2's, etc.
> I want 1, 2, 3, ...23, 30
> I keep getting 1, 2, 23, 3, 30
> Thank you in advance for your help!
sorting numbers in a column posted by Melissa on Mon, 6 Oct 2003