Unwanted decimal places in a mail merge from Excel

K

Kurch

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?
 
D

Doug Robbins - Word MVP

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


--
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
 
Top