Looking for cells containing numbers

[Thorkild]

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

 

[Max]

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

 

[Max]

Or, maybe something closer to your subject line ..

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