View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Snake2135 Snake2135 is offline
external usenet poster
 
Posts: 5
Default Round a repeating decimal from a formula...

here's my situation: I need to round all decimals that result from an IMDIV
function to two decimal places. I have Excel 2007, I have already tried
numerous ROUND functions, formatted the cells to round to two decimal places.
But on repeating decimals it will not round, only on solid results it will
round to two decimal places, thanks in advance.