 |
 | 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 / Publisher / General MS Publisher Questions / February 2008Mail Merge
Even after I have formatted the cells in Excel (currency, $, 2 decimals), when I try to bring that data into publisher for my mail merge, it has multiple numbers past the decimal point, i.e instead of $125.26 it shows up as $125.265. Seemed to try everything and can't correct. Any suggestions< Thanks > Even after I have formatted the cells in Excel (currency, $, 2 decimals), > when I try to bring that data into publisher for my mail merge, it has > multiple numbers past the decimal point, i.e instead of $125.26 it shows up > as $125.265. Save as a CSV file and merge from that. Publisher completely ignores Excel's cell formatting, as you've found out.  SignatureEd Bennett - MVP Microsoft Publisher http://ed.mvps.org |
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.