#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
marober7 marober7 is offline
external usenet poster
 
Posts: 1
Default mail merge

Using MSWord 2007 I am attempting to use mail merge to fill out a form.
Everything seems to work fine, except that in the merge the number "8.7"
becomes "8.699999 . . 93" I don't know if the issue is in Word or if it is in
Excel.

The number entered in Excel is 8.7. It isn't a calculated value. It was a
vlookup entry, but I eliminated even that and just entered 8.7 in the cell.
Cell is formatted for one decimal place.

Any thoughts?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge

In the mail merge main document, toggle on the display of fields codes
(Alt+F9 and add the following formatting switch to the mergefield inside the
closing }

\# 0.0

For more information on formatting Word fields with switches see the
following page of fellow MVP Graham Mayor's website:

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, originally posted via msnews.microsoft.com
"marober7" wrote in message
...
Using MSWord 2007 I am attempting to use mail merge to fill out a form.
Everything seems to work fine, except that in the merge the number "8.7"
becomes "8.699999 . . 93" I don't know if the issue is in Word or if it is
in
Excel.

The number entered in Excel is 8.7. It isn't a calculated value. It was a
vlookup entry, but I eliminated even that and just entered 8.7 in the
cell.
Cell is formatted for one decimal place.

Any thoughts?


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 06: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
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. Chris Green Mailmerge 5 October 8th 05 03:51 PM
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe F. Ferrer Microsoft Word Help 0 February 2nd 05 09:27 PM
mail merge doc with further linked/embedded mail merge docs not playing the game Rob Cowlard Mailmerge 3 January 8th 05 10:15 AM


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