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.