Looking for cells containing numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thorkild - 23 Feb 2005 08:43 GMT

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

Reply to this Message

Max - 23 Feb 2005 10:59 GMT

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

Signature

--
Rgds
Max
xl 97
---
GMT+8, 1? 22' N 103? 45' E
xdemechanik <at>yahoo<dot>com
----

> Hi,
> in a column with cells containing either text or numbers I have to exclude
[quoted text clipped - 5 lines]
>
> Cheers, Thorkild

Reply to this Message

Max - 23 Feb 2005 11:39 GMT

Or, maybe something closer to your subject line ..

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

Signature

--
Rgds
Max
xl 97
---
GMT+8, 1? 22' N 103? 45' E
xdemechanik <at>yahoo<dot>com
----

Reply to this Message