Thread: rounding problems
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default rounding problems
But 2565.48 round DOWN to 2565
Are you using functions or formatting?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kim" wrote in message
...
Why does 2565.48 round to 2566 and 3136.90 round to 3136?
My whole worksheet appears to be inconsistent. How can I set the entire
sheet to round up at .50+ and down at .49-?


Reply With QuoteReply With Quote