Jay,

This is a nit, but the pair of quotes isn't really needed, as long as the
second semicolon is there.
###;-###;
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jay" wrote in message
8.16...
If the answer to the formula is 0, how can I make it just show the
cell as empty instead of actually putting a 0 in the cell?

One way:
Tools Options View
And un-check "zero values."

Another way:
Format Conditional formatting
and set the font color to the background color when a cell is zero.

Another way:
=IF( <formula=0, "", <formula )

Another way:
Format Cells Number Custom
And put the following for Type:
###;-###;""

(I have Excel 97.)