Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Christy Skinner[_2_] Christy Skinner[_2_] is offline
external usenet poster
 
Posts: 2
Default Merging Excel calculation into word

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merging Excel calculation into word

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

"Christy Skinner" wrote in
message ...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging from Excel to Word Katie H. - Ultimate Health Mailmerge 1 January 12th 08 09:15 AM
Merging Excel to Word Geri Mailmerge 4 October 25th 07 10:58 PM
Simple table calculation: Excel or ??? LurfysMa New Users 2 June 30th 07 01:06 AM
Simple table calculation: Excel or ??? LurfysMa Tables 2 June 30th 07 01:06 AM
Merging from Excel to Word. Tree Branch[_2_] Microsoft Word Help 2 May 22nd 07 05:32 AM


All times are GMT +1. The time now is 05:27 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"