Excel rounding and Word mail merge rrrrr....
Solved
dv59
Posted messages
1210
Registration date
Status
Membre
Last intervention
-
NANOU -
NANOU -
Hello,
An Excel spreadsheet, columns of figures some entered manually, others calculated by formulas, and a Word document using mail merge that incorporates these figures.
The problem: no matter what format is tried (standard, number, accounting), the output in the mail merge sometimes shows numbers with 2 decimal places (what I typed, e.g., 12.50) but also numbers with up to about 8 decimal places even for figures entered manually like 12.5, which becomes, for example, 12.499999999
Office 2007
???
Thank you
Configuration: Windows 7 64 bit. Nvidia G210 Dual core 2.6 GHz
An Excel spreadsheet, columns of figures some entered manually, others calculated by formulas, and a Word document using mail merge that incorporates these figures.
The problem: no matter what format is tried (standard, number, accounting), the output in the mail merge sometimes shows numbers with 2 decimal places (what I typed, e.g., 12.50) but also numbers with up to about 8 decimal places even for figures entered manually like 12.5, which becomes, for example, 12.499999999
Office 2007
???
Thank you
Configuration: Windows 7 64 bit. Nvidia G210 Dual core 2.6 GHz
3 réponses
re,
Thank you very much, I managed to get it working with the field code:
my field name\#0.00
With a comma instead of a point and making sure not to be in mail merge preview and checking the box: keep formatting on each update so that everything is saved for each record...
Phew... even though I don't fully understand the structure of the code and what to do when it comes to something else like dates for example, at least the situation is resolved. The developers could look into this issue anyway (I'll see where we can report it)
Thanks again!
See you later!
Thank you very much, I managed to get it working with the field code:
my field name\#0.00
With a comma instead of a point and making sure not to be in mail merge preview and checking the box: keep formatting on each update so that everything is saved for each record...
Phew... even though I don't fully understand the structure of the code and what to do when it comes to something else like dates for example, at least the situation is resolved. The developers could look into this issue anyway (I'll see where we can report it)
Thanks again!
See you later!
Thanks again, and it's simple when you think about it
NANOU