Re: sorting numbers in a column

Giganews Newsgroups
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.

--
Dana DeLouis
Using Windows XP  &  Office XP
= = = = = = = = = = = = = = = = =

"Melissa" <melissahurl…@aol.com> wrote in message
news:27b501c38c6f$e0aabc10$350128…@phx.gbl...
> 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!

Replies

None

In response to

sorting numbers in a column posted by Melissa on Mon, 6 Oct 2003