On Apr 8, 11:37*am, supersonikk
wrote:
Hi all,

Is there a way to write a formula so that if a cell does not contain any
numbers, just text, it result as 0 number?

i.e.:

=if(C5<number,0,C5)

--
Thanks,
Marko

Try
=IF(ISERROR(VALUE(c5)),0,VALUE(c5))