|Subject:||Re: sorting numbers in a column|
|Posted by:||Dana DeLouis (ng_on…@hotmail.com)|
|Date:||Tue, 7 Oct 2003|
It appears you have numbers formatted as text as others have mentioned. If
you want to keep them this way, and you are using Excel XP, then don't use
the Sort toolbar button. Instead, use <Data> <Sort>. After you hit "ok",
Excel will prompt you as to how you want to sort the numbers.
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"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