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

[rilab]

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.

 

[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