#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mrupser mrupser is offline
external usenet poster
 
Posts: 1
Default Mail Merge

I'm creating a mail merge letter that takes numbers created by formulas in
excel as my data base. In my Excel spread sheet the numbers look like this:
301.29. But when I merge the document, they look like this in Word:
301.29999999999999
How do I merge the document so that the numbers look the same?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail Merge

By adding a formatting switch to the merge field - 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



"mrupser" wrote in message
...
I'm creating a mail merge letter that takes numbers created by formulas in
excel as my data base. In my Excel spread sheet the numbers look like
this:
301.29. But when I merge the document, they look like this in Word:
301.29999999999999
How do I merge the document so that the numbers look the same?



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
Error: Mail merge not completed....doesnot contain mail merge fiel Abhishek Dadu Mailmerge 3 January 1st 09 05:00 AM
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? gmax2006 Microsoft Word Help 1 March 28th 07 06:28 PM
collate pages in mail merge vs mail merge being single document Dan Schwab Mailmerge 2 September 14th 05 09:35 PM
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe F. Ferrer Microsoft Word Help 0 February 2nd 05 08:27 PM
mail merge doc with further linked/embedded mail merge docs not playing the game Rob Cowlard Mailmerge 3 January 8th 05 09:15 AM


All times are GMT +1. The time now is 08:19 PM.

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

About Us

"It's about Microsoft Word"