Sorting numerically

  • Thread starter Lionel Fridjhon
  • Start date
L

Lionel Fridjhon

When I sort by a column with numbers, the sort results in
all the numbers with left digit 8 coming before all the
numbers with left digit 7:

800 followed by 80 followed by 8 followed by 700 followed
by 70 etc.

The column is formatted for "Numbers", no decimal places.

How can I force the sort to be strictly numerical?

Lionel
 
F

Frank Kabel

Hi
are you sure your numbers are actually stored as numbers
and not as 'Text'. Try the formula
=ISNUMBER(A1)
if A1 stores one of your values. This should return TRUE
 
L

Lionel Fridjhon

Thanks Frank

The numbers are indeed Text. How can I change them to
numbers?

Lionel
 
F

Frank abel

Hi
one way:
- select an empty cell and copy it
- select your numbers
- goto 'Edit - Paste Special' and choose 'Add'

This should convert your 'text' numbers to real numbers
 

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


Top