View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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?