Re: sorting numbers in a column

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


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).


"Melissa" <melissahurl…> 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!



In response to

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