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