How to do a numercial sort?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I've got a column in a sheet that I'm trying to sort numerically but excel
will only sort it alphabetically, eg. 900 90 890 800 7 65...

I've tried formatting the cells as 'number' but this makes no difference.

The excel help says to convert text cells to number cells to click the cells
'marked with an error indicator'. None of the cells have an error indicator!

What am I missing?
 
Sean

Data previously formatted a text is difficult to convert back to numbers by
simply changing the format. To do this en masse, enter a 1 in a spare cell
and copy it. Highlight the stubborn cells and select edit>paste
special...>values+multiply

Now they will sort fine

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Struggles with Numercial Sorting. Please Help. 1
Sorting Dilemma 6
Sorting by rows with differing numbers of cell entries 3
Sort by colour 4
how can I sort a column numerically with both words and numbers i. 2
Sorting in Numerical Order 4
Sort with IF functions? 5
How fill cells with alpha series? 3

Back
Top