Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mark
 
Posts: n/a
Default Numeric rounding problems in mail merge with excel data source.

Hi,

Apologies if this has been posted before, I found nothing about this problem
in the FAQ or Google.

After upgrading from Office 2000 to 2003 a word mail merge, that uses an
excel spreadsheet as a data source, will corrupt any numeric decimal placing
data it is supposed to display. Any values in the spreadsheet that happen
to be a whole number are incorrectly rounded when displayed in the word
'Mail Merge Recipients' window.

E.G.: the spreadsheet correctly rounds the value 6.858 to 6.86, but mail
merge displays it as 6.857999999999997

The spreadsheet and word document were both designed (and still work) in
Word and Excel 2000, but not 2003.

Any ideas?

Thanks

Mark



  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Numeric rounding problems in mail merge with excel data source.

If you select Options from the Tools menu and then go to the General tab and
check the box against "Confirm conversions at open" and then when you attach
the datasource to the mail merge main document, you select DDE as the method
of connection, the behaviour will probably be the same as in Office 2000.

Otherwise, see "Formatting Word fields with switches" on fellow MVP Graham
Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mark" mark-at-redfox-dot-co-dot-uk wrote in message
...
Hi,

Apologies if this has been posted before, I found nothing about this
problem in the FAQ or Google.

After upgrading from Office 2000 to 2003 a word mail merge, that uses an
excel spreadsheet as a data source, will corrupt any numeric decimal
placing data it is supposed to display. Any values in the spreadsheet
that happen to be a whole number are incorrectly rounded when displayed in
the word 'Mail Merge Recipients' window.

E.G.: the spreadsheet correctly rounds the value 6.858 to 6.86, but mail
merge displays it as 6.857999999999997

The spreadsheet and word document were both designed (and still work) in
Word and Excel 2000, but not 2003.

Any ideas?

Thanks

Mark





  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mark
 
Posts: n/a
Default Numeric rounding problems in mail merge with excel data source.

Thanks Doug, that information was extremely useful!



"Doug Robbins - Word MVP" wrote in message
...
If you select Options from the Tools menu and then go to the General tab
and check the box against "Confirm conversions at open" and then when you
attach the datasource to the mail merge main document, you select DDE as
the method of connection, the behaviour will probably be the same as in
Office 2000.

Otherwise, see "Formatting Word fields with switches" on fellow MVP Graham
Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mark" mark-at-redfox-dot-co-dot-uk wrote in message
...
Hi,

Apologies if this has been posted before, I found nothing about this
problem in the FAQ or Google.

After upgrading from Office 2000 to 2003 a word mail merge, that uses an
excel spreadsheet as a data source, will corrupt any numeric decimal
placing data it is supposed to display. Any values in the spreadsheet
that happen to be a whole number are incorrectly rounded when displayed
in the word 'Mail Merge Recipients' window.

E.G.: the spreadsheet correctly rounds the value 6.858 to 6.86, but mail
merge displays it as 6.857999999999997

The spreadsheet and word document were both designed (and still work) in
Word and Excel 2000, but not 2003.

Any ideas?

Thanks

Mark







Reply
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
Using HTML file as data source for Mail Merge thenin Mailmerge 4 November 21st 05 09:03 AM
word cannot open file as a data or header source bec it is a mail merge main doc gerry Mailmerge 1 November 20th 05 02:24 PM
Unable to open excel data source for word mail merge Trisha Microsoft Word Help 0 October 18th 05 10:59 AM
printing a data source from a mail merge document Ann Mailmerge 1 August 3rd 05 04:48 AM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM


All times are GMT +1. The time now is 02:14 PM.

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"