Hi Matthew,

Thanks for the reply. I've used Fred's formula for the moment but am sure
I'll find your formula to good use in the other templates I'll be working on.

--
Thanks,
Marko


" wrote:

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