 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2006Excel $ merges with multiple numbers after decimal in Word. Why?
When I merge an Excel file into a Word document, the dollar amount column (with a formula) comes across in my Word document with multiple numbers after the decimal point. Is there some special way the Excel column should be formatted? I have tried many ways and am ready to pull my hair out! Hi Bonnie, You can control this by adding a numeric picture switch to your mergefield. If you select the existing mergefield and press Shift-F9, you should see something like: {MERGEFIELD ExcelValue} Change this to: {MERGEFIELD ExcelValue \# $,0.00} or something similar, then run your merge. See Word's help file for more information of field formatting. Cheers > When I merge an Excel file into a Word document, the dollar amount column > (with a formula) comes across in my Word document with multiple numbers after > the decimal point. Is there some special way the Excel column should be > formatted? I have tried many ways and am ready to pull my hair out!
|
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.