Is there a way to have Excel automatically change the cell value from
being a function the just being the value of the function? For example
From:
cell value= 1+2 :DISPLAY: 3
To:
cell value= 3 :DISPLAY: 3
Or someway to store that data in another cell would be nice too. I know
that you can copy the value of a function to another cell, but I want it
to automatically do this that way I can write a program that will
prepare itself for the next month overnight without any employees
having to format the data, and rewrite it.
~Greg
--
gregory.barrett
------------------------------------------------------------------------
gregory.barrett's Profile:
http://www.excelforum.com/member.php...o&userid=32421
View this thread:
http://www.excelforum.com/showthread...hreadid=527763