Replacing Formula with a Value

[Ron Bernstein]

Is there a way in native EXCEL to replace a formula with a
value, so a value is then stored in the cell.

I have a formula which checks if the date in each row is
today's date, using the TODAY() function. I it evaluates
true (today's date), then I read the values from a row of
cells near the top of the sheet.

I want to be able to replace the formula with a value if
the formual evaluates true.

Thanks for your help.

 

[Frank Isaacs]

Copy the cell(s) in question, then choose Edit | Paste Special... and choose
"values" in the dialog. Click OK, and the formula will be replaced.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com