Currency number format in form letters

[Wilfred]

I created a form letter and I get the source data from an Excel spreadsheet.
One of the items in the spreadsheet is a price.

The Word mail merge is correctly picking up the price data from the Excel
spreadsheet but I cannot figure out how to format the numeric data in the
Word form letter. A price of $699,000 is showing up as 699000. I tried
creating a table in the Word document and formatting the cell to currency,
but Word does not appear to have the cell formatting options that Excel has.

How can I get the numbers to display as currency ($699,000.00) or as numbers
with fixed decimal positions (699,000.00)?

 

[HDS]

There must be an easier way, but a workaround is to ad a formula with the
same result. Then you can ad number format.

"Wilfred" <[email protected]> schreef in bericht
I created a form letter and I get the source data from an Excel spreadsheet.
One of the items in the spreadsheet is a price.

The Word mail merge is correctly picking up the price data from the Excel
spreadsheet but I cannot figure out how to format the numeric data in the
Word form letter. A price of $699,000 is showing up as 699000. I tried
creating a table in the Word document and formatting the cell to currency,
but Word does not appear to have the cell formatting options that Excel has.

How can I get the numbers to display as currency ($699,000.00) or as numbers
with fixed decimal positions (699,000.00)?

 

[Martha]

I created a form letter and I get the source data from an Excel spreadsheet.
One of the items in the spreadsheet is a price.[...]
How can I get the numbers to display as currency ($699,000.00) or as numbers
with fixed decimal positions (699,000.00)?

In the form letter, right-click the field that needs to be displayed
as currency, and select Toggle Field Codes. You'll get something like
{ MERGEFIELD MyPrice }
(where MyPrice is the name of the field, and the curly braces look
bold - note that despite appearances, these are not the curly braces
you can type using your keyboard.)

Put the cursor after the last letter of your field name and add a
space, then the following switch:
\#

and the following 'picture', or number format:
$#,###

The field should now look like
{ MERGEFIELD MyPrice \# $#,### }

(Note the spaces.)

Hit Alt-F9 (or right-click and select Toggle Field Codes) to turn off
the curly braces.

When you merge, you should now get the price displayed as currency. If
you don't want the dollar sign, you can leave it out (so the number
format becomes '#,###').