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
----