In Office 2000 the formatting in Excel (e.g. Currency, %, etc.) is drawn into Word during the mail merge, BUT it is COMPLETELY lost in XP.
The Help file (Topic: Format merged data) reads as follows:
"To format merged data, you must format the merge fields in the main document. Don't format the data in the data source, because its formatting isn't retained when you merge the data into the document.
Why, it seems as though MS has gone backwards, say what!
Can anyone help me to keep the formatting in Excel in Word? It changed 40% to 0.4000000000000002, for example, and $2, 123, 123.00 to 2123123.00000000.