Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel / Word Merge Feature
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel / Word Merge Feature
See Cindy Meister's page
Force Word to use the number format you want http://homepage.swissonline.ch/cindymeister/mergfaq.htm In article , 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. Ive even tired recreating the entire Word doc and still it formats incorrectly. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel / Word Merge Feature
AMAZING! Thank you!
"JE McGimpsey" wrote: See Cindy Meister's page Force Word to use the number format you want http://homepage.swissonline.ch/cindymeister/mergfaq.htm In article , 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
Excel data source will not merge changes to Word | Excel Discussion (Misc queries) | |||
There should be a mail merge feature between excel and access. | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Excel cell filler for word merge document | Excel Discussion (Misc queries) |