It truncates the 'actual' value, formatting truncates the display only

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"PA" wrote in message
...
Couldnt find the answer with extensive searches:
Does the Round function round the number of significant digits stored in a
cell, or does it round the number displayed?
I believe it to be the latter, but need confirmation.

Thank you.