Thread: Changing formula to a value

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!

1) Select and Copy the cells
2) With cells still selected, use Edit | Paste Special with Values checked.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"newbie101" <newbie101.2cmwaq_1155733812.8566@excelforum-nospam.com> wrote
in message news:newbie101.2cmwaq_1155733812.8566@excelforum-nospam.com...
>
> 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!
>
>
> --
> newbie101
> ------------------------------------------------------------------------
> newbie101's Profile:
> http://www.excelforum.com/member.php...o&userid=37593
> View this thread: http://www.excelforum.com/showthread...hreadid=572167
>