decimal points when merged with Excel formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yma - 29 Apr 2004 17:39 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 30 Apr 2004 03:49 GMT

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

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

Signature

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

> When I merged Excel spreadshheets to Word documents, the
> number of decimal points shows up on the merged Word
[quoted text clipped - 7 lines]
> solve this problem? I would like to be able to maintain
> two decimal points on the merged Word document. Thank you.

Reply to this Message

Pam - 30 Apr 2004 18:20 GMT

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
[quoted text clipped - 8 lines]
>solve this problem? I would like to be able to maintain
>two decimal points on the merged Word document. Thank

you.

Reply to this Message

Rate this thread: