Sort Data Numbers Problem

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?
 
A

Arvi Laanemets

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
 
J

Jumbo

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.
 
Top