Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
John Richmond, Watford UK
 
Posts: n/a
Default ExcelWord Mail merge transfers 16 digits when Excel shows only 3

In producing reports by mailmerge from Excel into Word, an Excel cell holding
a calculated value formatted to display as 3.45 will be shown as
3.449993782999200000. Even cells carefully formatted to integers e.g 3 will
often transfer to 3.0000000000000001. Percentages such as 78% get
transferred as 0.798745300322220 Only if the values have been typed in will
the mail merge show the correct number.

This did not happen with previous versions of Word and Excel, where the
number was transferred as formatted in Excel. Is there any way of putting
this right?

Versions in use are Word 2002 SP3 and Excel 2002 SP3


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Fractions in Mail Merge. John McGhie [MVP - Word and Word Macintosh] Mailmerge 4 March 22nd 06 08:55 AM
Mail Merge Word 2003 Excel 2003 database Gwendolyn Mailmerge 1 February 8th 06 02:59 PM
cannot mail merge from excel to word Alan Mailmerge 3 October 26th 05 05:03 AM
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi Los Mailmerge 1 May 4th 05 02:52 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM


All times are GMT +1. The time now is 12:35 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"