 | Insert and format the current date and time |  | Show All |
|
Do any of the following:
| Insert a static date or time |
-
Select the cell.
-
Do one of the following:
To insert the | Select a cell and press |
|---|
Current date |
CONTROL+SEMICOLON
(;) |
Current time | ⌘+SEMICOLON
(;) |
| Insert a date or time whose value is updated |
-
Select the cell.
-
Do one of the following:
To insert the | Type |
|---|
Current date | =TODAY() |
Current date and time | =NOW() |
 | Note The
TODAY and
NOW functions change only when the sheet is recalculated. Functions are not updated continuously. The date and time values are updated from the computer's system clock. |
| Change the date or time format |
-
Select the cell.
-
On the Home tab, under Number, click the Number Format box 
, and then click Custom.
-
Under Category, select Date or Time, and then select a format in the Type list.
| Note Excel
cannot display both a time and a date format in the same cell. When you select one format, the other information will no longer be displayed in the cell. |
Share your feedback about this topic
