Microsoft Office Tutorials and References
In Depth Information
Enter a Date or Time into a Cell
Enter a Time
1 Click the cell in which you want
to enter the time.
C Excel marks the current cell by
surrounding it with a thick,
2 Type the time.
Note: See the following tip to
learn which time formats your
version of Excel accepts.
3 When your time is complete,
D If you do not want Excel to
move the selection, click Enter
( ) or press + instead.
Excel closes the cell for editing.
How can I tell which date and time formats my
version of Excel accepts?
Follow these steps:
1 Click the Home tab.
2 Click the dialog box launcher button ( )
in the bottom-right corner of the Number
3 Click the Number tab.
4 Click Date .
5 Click the Locale (location) drop-down
arrow ( ) and then click your location.
6 Examine the Type list to see the formats
you can use to enter dates.
7 Click Time .
8 Examine the Type list to see the formats
you can use to enter times.
9 Click Cancel .