 |
 | 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 / January 2006merge fields from excel are formating with too many decimal positi
I have a field in excel that has 7.55 but the mail merge is showing it as 7.5499999999998. the cell in excel only has the value of 7.55 and I have tried formating it as number, currency with 2 decimals and does not make a difference. it happens on several lines but not all lines Word pulls the VALUE, not the VIEW of the cell. Click on the cell and look at the formula bar. THAT is what Word will pull. See this article to fix it; should only take a few moments: http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com >I have a field in excel that has 7.55 but the mail merge is showing it as > 7.5499999999998. the cell in excel only has the value of 7.55 and I have > tried formating it as number, currency with 2 decimals and does not make a > difference. it happens on several lines but not all lines the value was 7.55 in the formula bar. But I did already find an article about switches and I was able to fix it with \###.##. thanks for your response > Word pulls the VALUE, not the VIEW of the cell. Click on the cell and look > at the formula bar. THAT is what Word will pull. See this article to fix it; [quoted text clipped - 10 lines] > > tried formating it as number, currency with 2 decimals and does not make a > > difference. it happens on several lines but not all lines You're welcome. :) ************ Hope it helps! Anne Troy www.OfficeArticles.com > the value was 7.55 in the formula bar. But I did already find an article > about switches and I was able to fix it with \###.##. thanks for your [quoted text clipped - 19 lines] >> > make a >> > difference. it happens on several lines but not all lines |
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.