Typo:

=IF(ISERROR(A1),0,A1)

--
Kind regards,

Niek Otten


"Niek Otten" wrote in message ...
| =IS(ISERROR(A1),0,A1)
|
| --
| Kind regards,
|
| Niek Otten
|
| "Monty" wrote in message ...
|| How can i change the cell from this (#REF) to this (0.00) or can i just hide
|| this ref.
||
|| Any help Please
|
|