View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JDueck
 
Posts: n/a
Default Can I stop Excel from seeing more than 2 digits after decimal?

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?