View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xlbo
 
Posts: n/a
Default Round near to Zero

Excel always rounds if values are held to more dp than are shown
Use the INT function to stop excel rounding automatically - this will cut
off numbers at the dp so be careful with it as sums may not add up !!
--
Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"


" wrote:

Excel NEVER rounds unless told to, BUT the cell may display a rounded
value if formatted that way - perhaps I've misunderstood the post
though!