Merging Excel Doc into Word.

  • Thread starter Thread starter Rose
  • Start date Start date
R

Rose

Does anyone know how to fix Word, or set the preferences,
so the decimals in the Excel worksheet flow into the Word
Document? My numbers are not transferring over - for
example 9.00 in the excel spreadsheet is 9, or 4.50 is
4.5, in the Word doc once I've merged the data. I need
the entire number to transfer over.

Rose
 
Why not use copy/paste. The data will come over in a
table format in Word. If you don't want a table, choose
Copy/Paste Special/Unformatted Text
 
To specify a number of decimals in a Word merge, you can modify the
field codes:

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 with two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
 
Back
Top