Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging from Excel to Word | Mailmerge | |||
Merging Excel to Word | Mailmerge | |||
Simple table calculation: Excel or ??? | New Users | |||
Simple table calculation: Excel or ??? | Tables | |||
Merging from Excel to Word. | Microsoft Word Help |