The formula for spreadsheetscurrent date-time is =now()
. This can be used to create a static timestamp as follows:
- Enter
=NOW()
in a cell - Copy this value with CtrlC
- Paste into the same cell with CtrlShiftV (or equivalents for "paste text only" on other platforms)