Looking for cells containing numbers
 

Hi,
in a column with cells containing either text or numbers I have to exclude
those with text in an arithmetic formula as is runs through the whole column,
hence avoiding an error as a result when reading text cells.
A cloumn holding an intermediate result of the reading as "0" or "1" or
something will be just fine.
How to?

Cheers, Thorkild

You might be thinking of something like this ?

Assuming the col with text/numbers is col A, A1 down

Put in B1: =IF(ISTEXT(A1),0,A1)
Copy B1 down

Then use col B instead of col A for downstream calcs
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Thorkild" wrote in message
...
Hi,
in a column with cells containing either text or numbers I have to exclude
those with text in an arithmetic formula as is runs through the whole
column,
hence avoiding an error as a result when reading text cells.
A cloumn holding an intermediate result of the reading as "0" or "1" or
something will be just fine.
How to?

Cheers, Thorkild

Or, maybe something closer to your subject line ..

Put in B1: =IF(ISNUMBER(A1),A1,0)
Copy down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----