Merging Excel calculation into word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christy Skinner - 28 Apr 2008 17:11 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 28 Apr 2008 20:24 GMT

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.

Signature

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

>I need to know how to get my calculations to look like they do in Excel
>after
[quoted text clipped - 4 lines]
>
> Christy Skinner

Reply to this Message

Rate this thread: