Merging Excel calculation into word

C

Christy Skinner

I need to know how to get my calculations to look like they do in Excel after
they are merged into a Word Doc. For example: I would like for a dollar
amount to include commas seperating the thousands from hundreds (
$123,446.00) but every time I merge it, it looks like this ($123446.00).
What do I do to get the comma to appear in Word doc.

Christy Skinner
 
D

Doug Robbins - Word MVP

In the mail merge main document, press Alt+F9 to toggle on the display of
field codes and add the following formatting switch inside the closing }

\# "$,0.00"

Use Alt+F9 again to toggle off the display of the field codes.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
Top