Can I stop Excel from seeing more than 2 digits after decimal?
ToolsOptionsCalculation 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
"JDueck" wrote in message ...
| 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?
|