Excel has some keyboard shortcuts to do this:
Insert Date: Ctrl + ;
Insert Time: Ctrl + Shift + ;
Alternatively, here are two other slightly more tedious, (but more flexible) ways to turn dynamic equations into fixed values:
1) After you've imputed your equations into want "Copy" then "Paste as Values" over the same cell(s). Can be for a single cell or a range of cells.
2) While imputing an equation highlight the part you no longer want to be volatile and press "F9" (e.g. highlight the "=NOW()" in your formula bar and press "F9", then "Enter" to keep the changes.)
Bookmarks