E
Erik Nettekoven
Hi,
When I use mail merge to merge an Excel in to a Word document, the merge
proces does makes a strange conversion or rather a strange round off.
For example the follwing excel rows:
B_HUUR N_HUUR KONTRAKTIN
482,95 482,26 30 april 2003
When I merge it into Word:
482,95 becomes 482,25999999999999
482,95 becomse 482,94999999999999
30 april 2003 becomes 4/30/2003
* When I try this in Office 2000 with the exact same excel sheet, the values
stay as they are, that means no addition of 9999999999.
* In excel the numbers are already exact, so no rounding off takes place in
the excel sheet.
* Both office 2000 as XP are Dutch versions;
* SP1 and 2 are installed only for XP
Please help
When I use mail merge to merge an Excel in to a Word document, the merge
proces does makes a strange conversion or rather a strange round off.
For example the follwing excel rows:
B_HUUR N_HUUR KONTRAKTIN
482,95 482,26 30 april 2003
When I merge it into Word:
482,95 becomes 482,25999999999999
482,95 becomse 482,94999999999999
30 april 2003 becomes 4/30/2003
* When I try this in Office 2000 with the exact same excel sheet, the values
stay as they are, that means no addition of 9999999999.
* In excel the numbers are already exact, so no rounding off takes place in
the excel sheet.
* Both office 2000 as XP are Dutch versions;
* SP1 and 2 are installed only for XP
Please help