Changing the format does nothing if the cells are text.

Format all to general then follow Mike's advice about the paste special bit.


Gord Dibben MS Excel MVP

On Mon, 6 Oct 2008 05:01:01 -0700, pearce
wrote:

I'm still struggling with this one. I don't get any warning it's just not
doing what it's asked to when I do data - sort. I've formated the cells to be
number cells but it's still leaving a random order of negative numbers - help!

"Mike H" wrote:

Hi,

Do you get a 'Sort Warning' when trying to do your sort?
If yes then select 'Sort anything that looks like a number as a number' and
try again. Excel should manage to sort them even if they are text.

If they are text and you want to change then to numbers put a one (1) in a
cell and copy it. Select your 'numbers' and then
Edit|Paste special
Select multiply and click OK.

Mike

Mike


"pearce" wrote:

I'm trying to sort a column of negative and positive numbers in excel 2003
but nothing seems to be happening. I've tried changing the type of cell but
haven't got anywhere, can anyone help?

e.g. after sorting I still have:

-6
-4
-2
-2
-6
0 etc