Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
PayPal Resolution Services
 
Posts: n/a
Default Why does mail merge change the numbers in excel

I have simple numbers in my excel document that mail merge draws from,
numbers like .76 when I mail merge them into msword the come out as
..759999999999999997 or .76000000000000000001 or stuff like that, I don't have
any idea what is happening to the numbers. I have tried all sorts of
different formating.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Why does mail merge change the numbers in excel

Word simply reads the underlying data from Excel. See
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


PayPal Resolution Services wrote:
I have simple numbers in my excel document that mail merge draws from,
numbers like .76 when I mail merge them into msword the come out as
.759999999999999997 or .76000000000000000001 or stuff like that, I
don't have any idea what is happening to the numbers. I have tried
all sorts of different formating.



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
Attaching different Excel files to emailed mail merge using merge. Pete Cuff Mailmerge 1 November 3rd 05 06:54 PM
mail merge using Word and Excel doesn't work correctly enolalum Mailmerge 2 October 29th 05 08:27 PM
cannot mail merge from excel to word Alan Mailmerge 3 October 26th 05 05:03 AM
Mail merge using an excel file Liberty Microsoft Word Help 1 February 16th 05 03:11 PM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM


All times are GMT +1. The time now is 04:45 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"