Hi all

Cell Result Formula
(672.00) (672) =--SUBSTITUTE(+$Cell,".",",")
(10.00) (10) =--SUBSTITUTE(+$cell,".",",")
#VALUE! =--SUBSTITUTE(+$cell,".",",")

any idea if i need to change the result from "#Value! to "zero" if the cell
is "nil"