Post the formulas that you are using. Formatting cells does not change the
underlying value that formulas would use, but that would not account for a
0.1 discrepancy when adding only two numbers.

Jerry

"adelaide" wrote:

hi we have a simple formula to work out employees pay (hourly rate x hours
worked = gross amount) however currently exel is not recognising a 6 as a 6
in the final total eg 520.16 +520.10 should = 1040.26 however it is showing
1040.15
also if .11cents shows it rounds it to 0 and 520.16=520.16 the total shows
1040.11 can someone please help i have not set it up to round up or down