Convert to numeric

thanhnguyen

New Member
ABC
10---45.20
-50---50.6
select sum (iif(isnumeric() = true, [A],0)) as SumofB
from Sheet1$

this return null value, how to check numeric on column B because of double --
 
Top