ToolsOptionsView, uncheck Zero values

--
Kind regards,

Niek Otten

"Mamarita" wrote in message
...
I'm creating a purchase order for our company and am having trouble
formatting some cells. I need a currency value in the Total section only
if
there is a value in the Quantity and Unit Price section. I formatted the
Total cells to Currency. But if there are no values in Quantity or Unit
Price, zero values appear in the Total cells. How do I format the total
cells
to only show price values when there are values in Quantity and Unit
Price?