Re: sorting numbers in a column

Giganews Newsgroups
Subject: Re: sorting numbers in a column
Posted by:  John Wilson (jwils…@optonline.net)
Date: Mon, 6 Oct 2003

Melissa,

You have the numbers formatted as text (which is why you're getting
that result).
Format the numbers as General or Number (and remove any
apostrophies you might have before the numbers).

John

"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