Merging an Excel Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RyckieJ - 02 Jun 2004 22:36 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 03 Jun 2004 00:06 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 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?

Reply to this Message