Merging with Word

T

toby

I am trying to merge a dollar amount into a word document, but it only inserts the numbers themselves - not the $ sign or the comma. I have the cell formatted as currency. In the cell it shows the correct formatting, but up on "fx" bar it just shows the numbers. I have also tried using different cell formats -- general, number -- but none of them seem to work. Help!!!
 
A

Andy B

Hi

You could use a helper column with:
=TEXT(A2,"$0.00")
in it.

--
Andy.


toby said:
I am trying to merge a dollar amount into a word document, but it only
Click to expand...
inserts the numbers themselves - not the $ sign or the comma. I have the
cell formatted as currency. In the cell it shows the correct formatting,
but up on "fx" bar it just shows the numbers. I have also tried using
different cell formats -- general, number -- but none of them seem to work.
Help!!!
 
D

Debra Dalgleish

In the Mail Merge, after you select your Excel file as a data source,
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and
your formatting will be retained.

If you have to connect through a different source, you can format the
fields in the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number as currency.
For example:
{ MERGEFIELD FieldName \# "$#,##0.00;($#,##0.00)"}
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
 
Top