Hello
=IF(ISERROR(yourformulahere),0,yourformulahere)

HTH
Cordially
Pascal
"Monty" a écrit dans le message de news:
...
How can i change the cell from this (#REF) to this (0.00) or can i just
hide
this ref.

Any help Please