|
As an alternative, if you only need the current date or time then you can these shortcut keys:
Enter the date CTRL+; (SEMICOLON)
Enter the time CTRL+SHIFT+: (COLON)
This will enter the date or time as a static value. In other words they will not update, unlike TODAY and NOW. If you are creating a spreadsheet, try not to use too many volatile Functions as this can slow down recalculation. As an alternative, using the NOW Function as an example, you could place the function into a cell somewhere and then reference that cell with a simple reference like: =A1. |
|