Sorting numerically

  • Thread starter Thread starter Lionel Fridjhon
  • Start date 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
 
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
 
Thanks Frank

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

Lionel
 
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
 
Back
Top