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 <at>yahoo<dot>com
----
"Thorkild" <[email protected]> wrote in message
news:[email protected]...
> 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 <at>yahoo<dot>com
----