Doug,

Only a macro can change the cell to something else. But this might be doable with a
self-referencing formula (circular reference). They are a bit of a pain, though. Why
don't you give your cell formulas and values? That'll be a bit less vague than your
description.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeyl.com
-----------------------------------------------------------------------
"DougL" wrote in message
...
Is there any way to have a formula within a cell automactially change to a
value by itself? To put this into context, here's a small example. In cells
A1:A12 I have the title of the months plus "forecast" (Jan Forecast, Feb
Forecast, March Forecast,...Dec Forecast). In cells B2:B13 I have the exact
same lookup formula referencing the same cell, G1 (value of 10). I use the IF
formula to not show anything in cells B2:B12 (for now), so let's just
concentrate on cell B1. So my result in B1 = 10. Cell G1 will change
automatically in another month to another value of say 23, so now I want cell
B2 (Feb) to show the 23, but cell B1 to still show 10. In order to do this
cell B1 has to convert to a value instead of a formula. Is there something I
can do rather than manually copying and past valueing the cell?