Sorting decimals

  • Thread starter Thread starter tcapewell
  • Start date Start date
T

tcapewell

I am trying to sort a column which contains decimal figures (ie 0.2
0.5, 1.3 etc) decending order but when I use the sort option eithe
nothing happens or the data is sort in an unusual way.

Surely Excel recognises decimals, or am I doing something very stupid?

Any help much appreciated

Many thanks

To
 
Hi Tom

Decimal numbers sort fine. Worst thing that should happen is that your
numbers are not recognized as numbers, but as simple text. If so they should
at least sort alphabetically (1, 11, 110, 2, 21, ... ). So Nothing Happens
is illogical no matter what. Hard to tell what's wrong without more detail
or actually seeing it.

HTH. Best wishes Harald
 
Does it matter if the figures have been generated through a formula?

I've made sure the figures are in Number format by going to Format
Cells, Number; but still nothing happen
 
Just changing the format won't change "text" numbers to "number" numbers.

One quick way is to select an empty cell and copy it.
select your range of "numbers" and edit|paste special|check Add
then try your sort.
 
If the formula is generating text, try using =VALUE(formula) before you
Paste Special|Values into the area that you want to sort.

You could also run into problems if you are trying to sort live formulas.

Jerry
 
Oops. I missed that part.



Jerry W. Lewis said:
If the formula is generating text, try using =VALUE(formula) before you
Paste Special|Values into the area that you want to sort.

You could also run into problems if you are trying to sort live formulas.

Jerry
Click to expand...
 
Back
Top