Data Sort

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

Guest

H
Simple question, seemingly easy answer....I have a column to the left of my data that has a number 1-x. I am trying to sort the list by this column and when executed it sorts but not numerically. Data>Sort>Column H, Im not changing any other settings This is part of the sort that I am getting
4
5
12
13
14
17
18
19
20
21
22
23
24
25
26
29
30
31
32
The 'skips' in the list show up further down on the sor

Any ideas
Thanks!
 
Steve,

1) If you have formulas in the first column, Excel will sort based on their
current value, and then they will recalc and get different values.

2) Some are numbers, some are strings with spaces or other non-visible
leading characters.

HTH,
Bernie
MS Excel MVP

Steve said:
Hi
Simple question, seemingly easy answer....I have a column to the left of
Click to expand...
my data that has a number 1-x. I am trying to sort the list by this column
and when executed it sorts but not numerically. Data>Sort>Column H, Im not
changing any other settings This is part of the sort that I am getting.
 
Column one contains entered text, Column H is entered numbers, in fact all columns are entered no formulas at all
Thanks
 
Hi
you have probably formated column A as text and not as number. So excel
does not do a numerical sort. Try the following:
- change the format of column A to 'General' or 'Number' (Format -
Cells')
- select an empty cell and copy this cell (hit CTRL+C)
- select your values in column A
- goto 'Edit - Paste Special' and choose the action 'Add'

Now try to sort again (column A now contains numbers)

--
Regards
Frank Kabel
Frankfurt, Germany

Steve said:
Column one contains entered text, Column H is entered numbers, in
Click to expand...
fact all columns are entered no formulas at all.
 
Back
Top