Microsoft Office Tutorials and References
In Depth Information
Entering dates and times in cells
Enter a date and time
1 Click the cell in which you want to enter a date and time.
2 Type a date, press the spacebar, and then type a time.
3 Press Enter.
1
2
Enter the current date and time
1 Click the cell in which you want to enter the current date and time.
2 Type =NoW() .
3 Press Enter.
1
2
TIP You can enter the current date by pressing Ctrl-; and the
current time by pressing Ctrl-Shift-;. These values are entered as
static values and won’t change when Excel recalculates the worksheet
where they’re entered.
CAUTIoN Different countries have different customs for
writing dates. For example, 07/04/13 could mean July 4, 2013, or
April 7, 2013, depending on where you live.
Search JabSto ::




Custom Search