Some values are off by a penny in the merged document

[Guest]

Some of the values in my merged document are off by a penny. I have a series
of figures listed and then a summation of those figures. The summation
figure coming from the excel data source, in some cases, is off by a penny.
For example, I have 3 figures ($4,125.32, $5,784.61, and $852.35) merged from
excel as well as a summed figure also coming from excel. The summed figure
in the merged document might display in the merged document as $10,762.27,
$10,762.28, or $10,762.29 even when cell from which the data is being merged
has $10,762.28 - the correct value. Is this a rounding issue or something
else? How do I ensure that the merged figure is not off by a penny?

 

[Doug Robbins]

I would suspect that it's a rounding issue that probably has to be fixed in
the data source. At the Word end, I believe that all you can really do is
control the number of decimal places.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[CyberTaz]

Howdy-

Excel is where this can be controlled. You might want to take a look at
Tools>Options>Calculation where there is a checkbox for 'Precision as
displayed".

*Review it in Help before you activate it* because there may be some adverse
consequences depending on the nature of your work. If so, you can always use
Edit>Move or Copy Sheet to copy the output to a separate workbook & set it
for Precision as Displayed and link to it.

HTH |:>)