Re: Formulas

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Edit the formula directly in the document: Press Alt+F9 to see the field
code. You'll see something like this: { = D6*1.175-D6 }. At the end of the
field code, just add \# "0.00;0.00;" (assuming 0.00 is the format you want
for positive and negative results). Press Alt+F9 to hide field codes. Press
F9 to update the field.

--
Stefan Blom
Microsoft Word MVP



"carol" <carol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E9EB3453-9E44-449C-9C29-77C5D46214C4@xxxxxxxxxxxxxxxx
Hi

Thanks very much, however it is still not working correctly. In my formula
i
have the following caluculation =d6*1.175-d6. (This is calculating the
VAT
on D6 then subtracting the amount, leaving just the VAT amount) .

Where would i insert the numeric picture switch?

Thanks

"Stefan Blom" wrote:

Use a numeric picture switch to specify different formats for positive,
negative, and zero results. The following simple example with a formula
field:

{ = 35 \# "00.00;(00.00);" }

would display 35.00 (since 35 is positive). A negative result would
display
in parentheses, and a zero result would not display at all.

--
Stefan Blom
Microsoft Word MVP



"carol" <carol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9CEE7A8-EA5E-4686-B282-F448F6E7AA92@xxxxxxxxxxxxxxxx
How do i hide a zero balance in word.





.

Relevant Pages

  • Re: Formulas
    ... Microsoft Word MVP ... "Stefan Blom" wrote: ... would display 35.00. ... and a zero result would not display at all. ...
    (microsoft.public.word.tables)
  • Re: Formulas
    ... "Stefan Blom" wrote: ... on D6 then subtracting the amount, leaving just the VAT amount). ... and a zero result would not display at all. ...
    (microsoft.public.word.tables)
  • Re: Formulas
    ... on D6 then subtracting the amount, leaving just the VAT amount). ... "Stefan Blom" wrote: ... and a zero result would not display at all. ...
    (microsoft.public.word.tables)
  • Re: Making 2 Tables into 1 Table
    ... All the tables created with Word 2003 display the same ... "Stefan Blom" wrote: ... Microsoft Word MVP ... Note that if you are saying that column widths do not match, ...
    (microsoft.public.word.vba.general)
  • Re: Pasted rows cause separate table
    ... Microsoft Word MVP ... "Stefan Blom" wrote: ... first display nonprinting marks (for example by pressing ... A header row set to repeat will not repeat after the point where the ...
    (microsoft.public.word.tables)