Microsoft Office Tutorials and References
In Depth Information
To Enter and Format the System Date
To Enter and Format the System Date
The following steps enter the NOW function and change the format from mm/dd/yyyy hh:mm to mm/dd/yyyy.
1
Click cell H2 and
then click the Insert
Function box in the
formula bar.
Insert Function
dialog box
Or select a category
box arrow
Insert Function box
inserts equal sign
in active cell and in
formula bar
When Excel displays
the Insert Function
dialog box, click the
‘Or select a category’
box arrow, and then
select Date & Time in
the list.
Date & Time
category
NOW function
selected
description of
selected function
Scroll down in the
Select a function list
and then click NOW
(Figure 3–21).
OK button
Figure 3–21
2
Click the OK button.
cell H2
assigned
NOW
function
When Excel
displays the Function
Arguments dialog
box, click the OK
button to display
the system date and
time in cell H2, using
the default date
and time format
mm/dd/yyyy hh:mm.
system time
system date
shortcut menu
Right-click cell H2 to
display the shortcut
menu (Figure 3–22).
Format Cells
command
Figure 3–22
 
 
Search JabSto ::




Custom Search