View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default formula with text and rounding

Errata.... I wrote:
This only rounds the __appearance__, not the actual
value. so 3.105 will appear as 3.11x, but 3 times
that cells will result in 9.32 (really 9.315), not 3.33.


A hopefully obvious typo: that should be 9.33.

And I should add: unless you set the "Precision as displayed" option. (Not
recommended.)