Merging an Excel Document

[RyckieJ]

I have a price list in Excel that I use for calculating our retail prices. I have built a mail merge document that imports my excel numbers to create price tags. Everything works except that the numbers that are brought over seem to have several trailing zeros and other odd digits (3.8800000029 should be 3.89). Any ideas?

 

[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


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

I have a price list in Excel that I use for calculating our retail prices.

I have built a mail merge document that imports my excel numbers to create
price tags. Everything works except that the numbers that are brought over
seem to have several trailing zeros and other odd digits (3.8800000029
should be 3.89). Any ideas?