As clarification, all numbers are added or subtracted in the workbook. It is
a budget program with all input in two decimal entry form (nothing automatic
or fractional).

As I noted in an earlier reply, the problem does not replicate in a new
workbook.

The 'ROUND' work-around works (see above). The base cause may be related to
formatting or some such thing. With it not replicating (I should have checked
that first) I am not sure it is worth pursuing further.

I really do appreciate all the time and thinking being provided for this
event. Your efforts and rapid responses are heart-warming.

"Wondering" wrote:

Yes but the OP did not specify how the numbers were derived. They are added
and formatted in accounting format with 2 places of decimal. The OP says
that cell Sheet2!D4 = Sheet1!C3 and that Sheet2!D4 is 381.9683. That means
that Sheet1!C3 must be 381.9683 and displays as 381.97 due to formatting.
Sheet1!C3 is the sum of Sheet1!C1 and Sheet1!C2 both of which are the sum of
two other cells. Somewhere along the way, 4 places of decimal were
introduced in these "other cells".

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
But wasn't the OP talking about adding, not multiplying?
--
David Biddulph

"Wondering" wrote in message
. net...
You're confusing internal representation with formatted numbers. When you
do calculations in Excel, the number of places of decimal changes to
follow the rules of mathematics. For example if you multiply a number
with 2 places of decimal by another number with 2 places of decimal you
get a number with 4 places of decimal as the result. Example: 12.34 *1.23
= 15.1782. If you format these 3 numbers to show with 2 places of
decimal, you'll see 12.34, 1.23 and 15.18. However the underlying value
in the cell showing 15.18 is still 15.1782. Formatting does not change
underlying values, unless you choose the set precision as displayed
option.

"Daan007" wrote in message
...
On sheet1: Cell C1 has value of the sum of two other cells. Cell C2 has
the
sum of two other cells. Cell C3 is the result of adding C1 and C2. All
numbers are to two decimals (Accounting format)
On sheet2: Cell D4 = 'sheet1'!C3 however when calculated, the number in
the
cell is to four decimal points and does not equal the number on sheet1
(C3 =
381.97 but D4 = 381.9683). What is causing this? All numbers are entered
as
two decimal place numbers and formatted as accounting (it is a budget
program). How do numbers with two decimal places become a smaller number
to
four decimal places when referenced from one sheet to another? This was
written in Excel 2007 and run in Excel 2007.