Unwanted decimal places in a mail merge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kurch - 15 May 2006 20:40 GMT

I am merging an Excel list to a Word mail merge document. Many of the
number fields are arrving into Word with many digits to the right of
the decimal point. I went back to Excel to make sure thsoe cells were
formatted with no digits to the right of the decimal point but I am
still getting numbers with about 8 unwanted digits.

Is it possible to format these numbers so that I don't have all these
unwanted decimals places?

Reply to this Message

Doug Robbins - Word MVP - 15 May 2006 22:18 GMT

Word merges the numbers as they are stored in Excel, not as the cells in
Excel are formatted to display them.

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

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

Signature

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

>I am merging an Excel list to a Word mail merge document. Many of the
> number fields are arrving into Word with many digits to the right of
[quoted text clipped - 4 lines]
> Is it possible to format these numbers so that I don't have all these
> unwanted decimals places?

Reply to this Message