Unless you can justify this, no it doesn't!!! It DISPLAYS to those number of
DP, but it doesn't round!
"xlbo" wrote in message
...
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!