Quote:
Originally Posted by rollis13
Have you tried my suggestion in post #2 ?
|
Yeah. Given OP's desire to leave the numerical values unchanged, just changing the formatting (as you have done), is probably what he needs. For other purposes though, changing the value could be useful. For example if he wanted a textual summary statement such as
Code:
="The measurement is: "&B1
then actually changing the value would be useful.
Though, as I write this, is accurs to me that
Code:
="The measurement is: "&TEXT(B1,"0.000\""")
would also work.