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

J

JDueck

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?
 
N

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?
 
T

Toppers

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
 
Top