Hi Andy,

I feared he wanted different format for 0 and non-zero :-)

Regards

Bob

<Andy B wrote in message ...
Bob
I was working on the theory that the cell would be formatted as 0.00, and
therefore the formula wouldn't need to check for being zero itself!

--
Andy.