Sort Data Numbers Problem

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

I have this data: -

Column A

A
B
C
D
E
F

Column B

10
11
102
67
19
12

When I ask excel to sort data in descending order. It puts column B in
this order:-

10
102
11
12
19
67

Obviously this isn't correct because it is reading 102 incorrectly.

How do I rectify this?
 
Hi

At least 102, but maybe some other entries also, is text.
To correct this:
1. Select all data in numeric column, and reset cell format for selection to
General or Numeric
2. Enter a number 1 somewhere into worksheet, and copy the cell.
3. Select all data in numeric column again, and then PasteSpecial.Multiply.
4. Delete the number 1, you entered in meanwhile.
It's all
 
Hi,
it look like you did a sorted data "ascending" with "header row" checked.
Always be sure to check if header row on the sort dialogue box is on or off.

Just an idea nothing more.
 
Back
Top