 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / August 2007How to merge monetary values from Excel to Word?
I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Or if I'm using a % amount, it shows up on Word as a long decimal. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! On 8/29/07 3:58 PM, in article 78CD4A46-E5CD-4076-8520-6A45ECB1FF8A@microsoft.com, "DSmithWBP" > I am trying to merge an excel worksheet to Word, but when I merge the > information, such as dollar amounts, i.e. 103,801,186, I lose the commas and [quoted text clipped - 3 lines] > greatly appreciated. > Thanks!! The problem is with Word, not Excel. Look in word help for "format merged Data". You will need to add switches to the merge field to format the data.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom On Aug 29, 3:58 pm, DSmithWBP <DSmith...@discussions.microsoft.com> wrote: > I am trying to merge an excel worksheet to Word, but when I merge the > information, such as dollar amounts, i.e. 103,801,186, I lose the commas and [quoted text clipped - 3 lines] > greatly appreciated. > Thanks!! I just tried it and had no problem. Then, I changed the formats in Excel, saved the changes and tried again in Word. The changes were NOT reflected in the merged document. After some trial and error, I found that I had to close and re-open the data source with the Word Data Merge manager before changes in formatting were recognized. You might try this as well. jpdphd See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- >I am trying to merge an excel worksheet to Word, but when I merge the > information, such as dollar amounts, i.e. 103,801,186, I lose the commas and [quoted text clipped - 3 lines] > greatly appreciated. > Thanks!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.