Hi J,

An alternate solution which might be considered is to suppress the display
of zero on the sheet. In that case you hide all 0's from view or printing
but they still remain in the cell. This effects the entire sheet on which
you apply it.

Choose File (Office Button), Excel Options, Advanced, Display options for
this worksheet, and uncheck "Show zero in cells that have zero value."
--

Cheers,
Shane Devenshire


"J" wrote:

I am using Excel 2007.
I am using the following formula to calculate the total cost based on 2 cells:
The formula is in Cell "F3" and is entered as this =B3*C3

How can I keep it from displaying $0.00 when the fields are empty?