Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2006

Tip: Looking for answers? Try searching our database.

mail merge with excel datasource

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Deb H - 14 Feb 2006 21:44 GMT
We are using a worksheet as the datasource for a Word Mail Merge.  The
problem is that the number figures are rounded to two decimals in Excel
(meaning 679.83) but when the information is pulled to Word the result for
the field is 679.83999999999.  Is there something I can do?
Signature

Deb H.

Anne Troy - 15 Feb 2006 03:23 GMT
Hi, Deb. There sure is:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

> We are using a worksheet as the datasource for a Word Mail Merge.  The
> problem is that the number figures are rounded to two decimals in Excel
> (meaning 679.83) but when the information is pulled to Word the result for
> the field is 679.83999999999.  Is there something I can do?
 
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.