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