I'm working on a spreadsheet with a lot of referenced formulas. I have
it set to where, for example, .08*19 displays the answer "2" because I
have it with no decimal places. But when I go to reference this
cell in another formula, I can't get it to use "2", it uses the actual
value which is 1.52, even though 2 is shown. I need it to
use the value shown in the calculation. Any idea of how I can get this
to use the displayed value?
Thanks


--
BrandenKilgore
------------------------------------------------------------------------
BrandenKilgore's Profile: http://www.excelforum.com/member.php...o&userid=26145
View this thread: http://www.excelforum.com/showthread...hreadid=394730