Formatting merge fields

Is there a way in Word 2003 to format a merge field to be
a number such as $###,###.##?

Dawn,

Sure. A numeric picture switch. From Word's Help file:

Specifies different number formats for positive and
negative results. For example, if the bookmark Sales95 is
a positive value, the field { Sales95 \# "$#,##0.00;-
$#,##0.00" } displays the value with regular formatting —
for example, "$1,245.65". A negative value is displayed
with bold formatting and a minus sign — for example, "-$
345.56".

See General SwitchesNumeric picture for more examples.


-----Original Message-----
Is there a way in Word 2003 to format a merge field to be
a number such as $###,###.##?
.

When I try =ABTotal_gift_amount=BB\# "$#,##0.00 I get=20
75000\# "$#,##0.00 - am I leaving out a command somewhere?
-----Original Message-----
Dawn,

Sure. A numeric picture switch. From Word's Help file:

Specifies different number formats for positive and=20
negative results. For example, if the bookmark Sales95=20
is=20
a positive value, the field { Sales95 \# "$#,##0.00;-
$#,##0.00" } displays the value with regular formatting -
=20
for example, "$1,245.65". A negative value is displayed=20
with bold formatting and a minus sign - for example, "-$=20
345.56".

See General SwitchesNumeric picture for more examples.


-----Original Message-----
Is there a way in Word 2003 to format a merge field to=20
be=20
a number such as $###,###.##?
.

.

Dawn,

You have to toggle the field code display. Select the fiedl and press
ALT+F9. You should then see something like { Mergefield
Total_gift_amount }. Put your switch inside the field code brackets e.g.,
{ Mergefield Total_gift_amount \# "$#,##0.00} and toggle the display again.
BTQ the switch
\# "$,0.00;($,0.00)" might be better.

--
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in

Dawn wrote:
When I try «Total_gift_amount»\# "$#,##0.00 I get
75000\# "$#,##0.00 - am I leaving out a command somewhere?
-----Original Message-----
Dawn,

Sure. A numeric picture switch. From Word's Help file:

Specifies different number formats for positive and
negative results. For example, if the bookmark Sales95
is
a positive value, the field { Sales95 \# "$#,##0.00;-
$#,##0.00" } displays the value with regular formatting -

for example, "$1,245.65". A negative value is displayed
with bold formatting and a minus sign - for example, "-$
345.56".

See General SwitchesNumeric picture for more examples.


-----Original Message-----
Is there a way in Word 2003 to format a merge field to be
a number such as $###,###.##?
.

.