Skip to main content
Notice removed Needs detailed answers by ChrisF
The answer does have a useful bit, so is worth saving.
Source Link
user79865
user79865

The formula for spreadsheetscurrent date-time is =now(). This can be used to create a static timestamp as follows:

  1. Enter =NOW() in a cell
  2. Copy this value with CtrlC
  3. Paste into the same cell with CtrlShiftV (or equivalents for "paste text only" on other platforms)

The formula for spreadsheets is =now()

The formula for current date-time is =now(). This can be used to create a static timestamp as follows:

  1. Enter =NOW() in a cell
  2. Copy this value with CtrlC
  3. Paste into the same cell with CtrlShiftV (or equivalents for "paste text only" on other platforms)
added 1 characters in body
Source Link
OnenOnlyWalter
  • 7.4k
  • 1
  • 35
  • 48

The formula for spreadsheets is =now ()=now()

The formula for spreadsheets is =now ()

The formula for spreadsheets is =now()

Notice added Needs detailed answers by ChrisF
Source Link

The formula for spreadsheets is =now ()