Microsoft Office Tutorials and References
In Depth Information
EX 184
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
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.
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
NOW function
Scroll down in the
Select a function list
and then click NOW
(Figure 3–21).
description of
selected function
OK button
Figure 3–21
Click the OK button.
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
cell H2
shortcut menu
Right-click cell H2 to
display the shortcut
menu (Figure 3–22).
Format Cells
Figure 3–22
Search JabSto ::

Custom Search