decimal points when merged with Excel formula

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.

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
"yma" wrote in message
...
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.

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'.

-----Original Message-----
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.
.