View Single Post
  #6   Report Post  
Stefan Blom
 
Posts: n/a
Default

I'm glad I could help.

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Works beautifully, Stefan.

Thanks heaps.

Anthony



"Stefan Blom" wrote in message
...
Try the following:

{ MERGEFIELD "item_No1" \# "$#.00;($#.00);" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi Stefan

First of all thanks for your response and I apologise for not

making
myself
clear.

If there is a zero value in the field I want to leave the field

completely
blank. Any suggestions?

Thanks
Anthony
"Stefan Blom" wrote in message
...
If you don't want the number zero to be displayed, use #

instead
of 0
before the decimal point (in the field code):

{ MERGEFIELD "item_No1" \# "$#.00;($#.00)" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi

How do I include a second switch in a field that already

contains
a
switch?

I want to create a field switch which controls the number of

digits
on the
right hand side of the decimal point and which also suppresses

zero
dollar
values

I know the following switch works to control the number of

digits
on
the
right hand side of the decimal point...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)"}

...but when I add a second switch (i.e., \#"$0.00;;") to the

above
field to
give the following field...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)" \#"$0.00;;"}

...I get the following error:

"Error! Too many picture switches defined."

Any suggestions would be greatly appreciated.

Thanks
Anthony