Sort fail

[outriding]

Hello i am doing a simple sort..

The spreadsheet is just 20 x 350

I select select a whole worksheet and ..

data, sort, header row select my column and click OK.

The spreadsheet sorts but the column i sort is not sorted. It onl
sorts the first number ( there are 6 and 7 digit numbers ) so the sor
looks like this..

12
15
17
2
21
23
3
41
44
45

and so on

I made sure the column i sorted was numbers ( it was general )

I cut and pasted this into a new sheet and it still did not work.

I think it might be releated to the format of the cells but i a
unsure.

any help would be great

 

[Frank Kabel]

Hi
looks like the values are interpreted as Text. If the formula
=ISNUMBER(I1) returns FALSE try the following
- format column I as number or General
- enter a 1 in anempty cell
- select this cell and copy the cell (CTRL+C)
- select column I
- goto 'Edit - Paste Special' and choose the action 'Multiply'

Now sort again