Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |