[Char]

My apologies if this is a dumb question but I have an invoice template that
I'm setting up as a fill-in form to do a pretty basic calculation
(qty*amount=total). The qty and amt fields are fine, as far as I can tell,
but the total fields are all showing the $0.00 even w/o any calculations.
This is due, I suspect to the use of the =product(a2,c2) formula since
removing it removes the auto-text.

Is there a way to have the above not show unless there is, in fact, a
calculation being done?

Thanks in advance for any help you can give.

[macropod[_2_]]

Hi Char,

You can supress the 0 display, but this will affect calculations that should evaluate to 0 (eg 10*0=0). To achieve the supression,
simply add a ';' to the end of the calculation field's number format. For example, you could change:
$#,##0.00;($#,##0.00)
to:
$#,##0.00;($#,##0.00);

--
Cheers
macropod
[MVP - Microsoft Word]


"Char" wrote in message ...
My apologies if this is a dumb question but I have an invoice template that
I'm setting up as a fill-in form to do a pretty basic calculation
(qty*amount=total). The qty and amt fields are fine, as far as I can tell,
but the total fields are all showing the $0.00 even w/o any calculations.
This is due, I suspect to the use of the =product(a2,c2) formula since
removing it removes the auto-text.

Is there a way to have the above not show unless there is, in fact, a
calculation being done?

Thanks in advance for any help you can give.