Sorting in Excel

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

How can I sort a column of numbers in Excel, i.e.
rearrange them in ascending order? Data/ Sort Ascending
does nothing. Thanks.
 
Hi
have you checked that your numbers are really stored as
numbers (and not as text values). Try the following
formula:
=ISNUMBER(A1)
 

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

VBA- Excel Programming:- 0
numbers in a column are not sorting ascending 2
Sorting Spreadsheet Help 4
Ascending 3
Sorting errs 6
Expand Selection in Auto filter 7
dates older than 1900 2
How do I get drop-down list that includes, eg top10 1

Back
Top