Posted to microsoft.public.word.mailmerge.fields
|
|
Excel data formatting change on Mailmerge
You need a formatting switch on the field - see
http://www.gmayor.com/formatting_word_fields.htm
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
watchtower wrote:
I'm trying to merge data from an excel file into a word document for
a mass mailing. Word is not using the source formatting, how can I
fix this? Example:
Merge Data:
ESP BOX C OVERRIDE
A423 2,574.51 643.63
A429 3,430.22 857.56
A439 6,641.06 1,660.27
Data viewable in Word:
BOX C
2574.5100000000002
3430.2199999999998
6641.0600000000004
These are not formulas in Excel... these have been manually entered.
Both "Box C" and the "Override" data are merging with additional
numbers. Some of the information does view correctly, but it seems
completely random. The weirdest thing is that this file worked last
week. I've even tired recreating the entire Word doc and still it
formats incorrectly.
Any suggestions?
|