13 numbers added to Word/Excel mail merge field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat - 18 Jan 2005 20:29 GMT

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 to this Message

Doug Robbins - 19 Jan 2005 02:10 GMT

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

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

Signature

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

> In MS Office Professional 2003, a Excel data colum which should return,
> for
[quoted text clipped - 6 lines]
> the added numerals. I have re-done the Word document, but still get the
> unwanted numbers. Any thoughts appreciated

Reply to this Message