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