Can I stop Excel from seeing more than 2 digits after decimal?

[Guest]

The horizontal formula line is calculating money past two places after the
decimal point, yet showing only the two places (which is what I want to see).
The vertical formula then adds the results from the horizontal formula, but
it calculates beyond 2 places after the decimal, and causes the bottom line
figure to reflect an incorrect amount. Can this be overcome?

 

[Niek Otten]

Tools>Options>Calculation tab, check "Precision as displayed".
Do read HELP first to know what this does. I use this often for financial spreadsheets.


--
Kind regards,

Niek Otten

| The horizontal formula line is calculating money past two places after the
| decimal point, yet showing only the two places (which is what I want to see).
| The vertical formula then adds the results from the horizontal formula, but
| it calculates beyond 2 places after the decimal, and causes the bottom line
| figure to reflect an incorrect amount. Can this be overcome?

 

[Guest]

JE McGimpsey's website addresses that exact situation:

http://www.mcgimpsey.com/excel/pennyoff.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

Round the invidual cells to 2 dec places (round(A1,2)) and this should
correct the problem. Third decimal place of 5 or greater will round up.

HTH