View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown[_4_] Gary Brown[_4_] is offline
external usenet poster
 
Posts: 209
Default rounding problems

You should answer Bernard in your first posting of this question and not ask
it twice, wasting our time.
--
Gary Brown


"Kim" wrote:

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