Forum Discussion
Solved
MAKE RESULT OF TODAY() AND NOW() FORMULAS STATIC IN A CELL
I need to convert the date and time values from TODAY() and NOW() formulas into static values into specific cells in a template. This has to be protected, in order to prevent the user of the workbook from changing it.
How do I make such a value static in the cell, as we can't use the method of entry via the keyboard (due to the protected status of the cell)?
Microsoft® Excel® for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20254) 64-bit
4 Replies
- Excel works live on data. So you can't stop it from calculating and updating a particular cell.
However, this is achievable via macro. The work around is that you write a macro where you select a cell (your entry date calculated via TODAY() or NOW() function) and press a button, which will replace the formula with the resultant value.- Thanks!
- Thanks!
