Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
ExcelWord Mail merge transfers 16 digits when Excel shows only 3
In producing reports by mailmerge from Excel into Word, an Excel cell holding
a calculated value formatted to display as 3.45 will be shown as 3.449993782999200000. Even cells carefully formatted to integers e.g 3 will often transfer to 3.0000000000000001. Percentages such as 78% get transferred as 0.798745300322220 Only if the values have been typed in will the mail merge show the correct number. This did not happen with previous versions of Word and Excel, where the number was transferred as formatted in Excel. Is there any way of putting this right? Versions in use are Word 2002 SP3 and Excel 2002 SP3 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Fractions in Mail Merge. | Mailmerge | |||
Mail Merge Word 2003 Excel 2003 database | Mailmerge | |||
cannot mail merge from excel to word | Mailmerge | |||
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi | Mailmerge | |||
mail merge with attachments | Mailmerge |