This might be old hat, but just in case you have not heard of the
trick:
Assume you have the result of your calculations in cell A1 and A2. In
cell B1 you write:
="Result of Calculations "&A1&" and "&A2
and then refer to cell B1 in the textbox.
Often the result is not a nice number and the you get all the
13-or-whatever digits. One solution is to write
="Result of calculations "&ROUND(A1,2-INT(LOG(ABS(A1))))&" and
"&ROUND(A2,2-INT(LOG(ABS(A2))))
but you can also round down in another cell and refer to that.
NSV
--
nsv
------------------------------------------------------------------------
nsv's Profile:
http://www.excelforum.com/member.php...o&userid=26500
View this thread:
http://www.excelforum.com/showthread...hreadid=479225