Imported data problem

Hi all,

I am helping a friend calculate some data using imported data (I am not sure where from) and the table may look as below.

---col A-----col B-----col C
11-------------10--------12

I am using if(and(A1<20,B1<20),C1*10

This should give me an answer of 120 but I get a FALSE statement return.

Col A and Col B although both numbers seem to be behaving differently.

The numbers in col A are to the far left of the column, all other column numbers are to the right.

If I actually type 11 into A1 the formula works ok.

I have tried formatting and pre-formatting the columns to no avail.

Is it something to do with the data being imported and is ther any way around it.

Thanks as always.

Greg.

The numbers is column A are being interpreted as text by excel. Does it work properly if you just enter the cell and then exit..?
Another thing you may try is:
Go to Data > Text to columns
Select delimited and click finish.

Mangesh

Thank you Mangesh,

the text to columns trick worked.

Greg.

Well, it has always worked for me in such cases.

Mangesh