Merge with Excel and decimal problems

[Larry]

I have a very large spreadsheet that contains a column of
amounts representing dollars and cents, another column
which multiplies that column by a percentage and then a
resulting column that adds the two previous columns
together. I have formatted those columns to
be "general", "accounting", "currency", and "special" and
have set it to be two decimals only. The columns appear
in the spreadsheet with only two decimals but when i
merge the final column number in to a word document, i
get all the calculated decimals (5 or 6). How do I get
rid of the extra decimal points so that the letter shows
a dollar amount with only 2 decimals. Anyone's help
would be appreciated.
..

 

[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