In mail merge from an excel source the number fields are too long

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rilab - 29 Aug 2006 00:27 GMT

When previewing the merge data the numbers from the excel data sourse have
too many digits - ie $ 15.6789678002. In the excel source the cell format
is set to 2 places only as either a number or currency. How do I get the 2
places to stay in tact in the document. Also it dropps the 0's when they
need to be there such as $1.50 is showing as $1.5.

Reply to this Message

Doug Robbins - Word MVP - 29 Aug 2006 04:36 GMT

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

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

Signature

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

> When previewing the merge data the numbers from the excel data sourse have
> too many digits - ie $ 15.6789678002. In the excel source the cell
[quoted text clipped - 3 lines]
> places to stay in tact in the document. Also it dropps the 0's when they
> need to be there such as $1.50 is showing as $1.5.

Reply to this Message