Reply
 
Thread Tools Display Modes
  #1   Report Post  
Pat
 
Posts: n/a
Default 13 numbers added to Word/Excel mail merge field

In MS Office Professional 2003, a Excel data colum which should return, for
example, 3.444 in the Word merge field insteads returns 3.4440000000000002,
adding 13 numbers to the field. Checks of the original Excel column shows
proper formatting for both the column and when checked individually. The
Excel text input bar at the top also displays the correct number with none of
the added numerals. I have re-done the Word document, but still get the
unwanted numbers. Any thoughts appreciated
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Pat" wrote in message
...
In MS Office Professional 2003, a Excel data colum which should return,
for
example, 3.444 in the Word merge field insteads returns
3.4440000000000002,
adding 13 numbers to the field. Checks of the original Excel column shows
proper formatting for both the column and when checked individually. The
Excel text input bar at the top also displays the correct number with none
of
the added numerals. I have re-done the Word document, but still get the
unwanted numbers. Any thoughts appreciated



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
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Field Stripping M. Johnson Mailmerge 3 January 12th 05 04:34 PM
Home Phone field not getting picked up in Merge Cathleen McGuire Mailmerge 4 January 7th 05 03:13 AM
How do I get a field to self adjust in a mail merge? DD Holt Mailmerge 1 December 29th 04 06:30 PM
Numbers reformatting during mail merge Sherry Formatting Long Documents 1 December 9th 04 03:47 PM


All times are GMT +1. The time now is 04:16 AM.

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"