Convert text to currency in MS Word 2007

[Susan May]

I have a mail merge that I've linked to an Access query. In the query I have
a currency field that has all the correct formatting, but when I insert the
field into Word, it drops the $ and the comma. I want my field to look like
this, $15,000. How do I make the field appear like this in my mail merge
document?

Many thanks for your help.

Susan

 

[Steve Yandl]

Susan,

During a merge, the formatting in the database is left behind. Start with
your Word document where you've inserted the merge fields. Select a field
(including the chevrons, << >> that surround it) and apply the appropriate
formatting. After you merge the data, use preview to make sure the
formatting looks the way you want.

Steve

 

[Susan May]

ok, I'll try that Steve. Thanks.

Susan,

During a merge, the formatting in the database is left behind. Start with
your Word document where you've inserted the merge fields. Select a field
(including the chevrons, << >> that surround it) and apply the appropriate
formatting. After you merge the data, use preview to make sure the
formatting looks the way you want.

Steve

 

[macropod]

Hi Susan,

In Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.

 

[Susan May]

Perfect. That worked. Thank you so much. Have a great weekend!

Susan

Hi Susan,

In Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values


The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.


--
Cheers
macropod
[MVP - Microsoft Word]

I have a mail merge that I've linked to an Access query. In the query I have
a currency field that has all the correct formatting, but when I insert the
field into Word, it drops the $ and the comma. I want my field to look like
this, $15,000. How do I make the field appear like this in my mail merge
document?

Many thanks for your help.

Susan