Changing formula to a value

N

newbie101

Hello,

I was wondering whether there is a function in Excel (or if it is
possible to write a Macro) that allows you to change the formula within
a given cell to just its value (that the formula calculated), if a
certain condition is met.

For example...cells will be populated for the March coloumn from the
March data spreadsheet. As soon as March is over, the values in the
March coloumn will be fixed, and the formulas within those cells will
be disabled.


Thank you!
 
B

Bernard Liengme

1) Select and Copy the cells
2) With cells still selected, use Edit | Paste Special with Values checked.
best wishes
 
Top