decimal points when merged with Excel formula

[yma]

When I merged Excel spreadshheets to Word documents, the
number of decimal points shows up on the merged Word
document does not follow the format in Excel. For example,
in Excel I have formatted the column to be with only two
decimal points (the original data was built by formula),
but when the spreadsheet is merged to Word, I still see
numbers with 9 or 10 decimal points. The problem remains
when I change the formula to numbers by copying and
pasting special (i.e. values). Does anyone know how to
solve this problem? I would like to be able to maintain
two decimal points on the merged Word document. Thank you.

 

[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

 

[Pam]

Your Excel formatting is lost when mail merge brings the
data over.

To get the same result in Word, add a numeric picture
switch to the
mailmerge field, like '\# 0.00', so that your field looks
something like:

{MERGEFIELD Data \# 0.00} or {MERGEFIELD Data \# 0.00 \*
Mergeformat}

A complete list of switches you can use to format fields
can be found by going into Word Help and searching
for 'General Switches'.