Merge data into word document form Excel, large signific number

[ecoeng]

When I merge data into a word document from an excel data sheet, I sometimes
get and excess of signficant number into the merged feild. For example when
I entered the number 7.8 in the excel data sheet the merged number in the
wrd dcument become 7.7999999999999998. How do I prevent this from happening?

Thanks

 

[Doug Robbins - Word MVP]

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

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