View Single Post
  #5   Report Post  
Bernard Liengme
 
Posts: n/a
Default An Inquirey on the Round function

Can an old academic have a good moan?
The round function (and formatting) alter the 'number of decimal places' NOT
the 'number of significant digits'.
Please see http://en.wikipedia.org/wiki/Significant_figure to learn what SIG
FIG is all about.
The number 12.12345 has 7 sig digits while 0.00001 has only 1; both have 5
decimal places.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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.