ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel data formatting change on Mailmerge (https://www.excelbanter.com/excel-discussion-misc-queries/125320-excel-data-formatting-change-mailmerge.html)

watchtower

Excel data formatting change on Mailmerge
 
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. Ive even tired
recreating the entire Word doc and still it formats incorrectly.

Any suggestions?


All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com