Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting Cells in a Worksheet
1
then click the Insert
Function box in the
formula bar to display
the Insert Function
dialog box.
Select cell I11 and
Insert Function
dialog box
Or select a category
box arrow
Click the ‘Or select a
category’ box arrow
(Insert Function dialog
box) and then select
Date & Time in the
list to populate the
‘Select a function’ list
with data and time
functions.
Insert Function box
inserts equal sign
in active cell and in
formula bar
Date & Time
category
NOW function
selected
description of
selected function
‘Select a function list’
and then click
NOW to select the
required function
(Figure 3 – 21).
Scroll down in the
OK button
Figure 3 – 21
2
Click the OK button
(Insert Function dialog
box) to close the
Insert Function dialog
box and display the
Function Arguments
dialog box.
cell I11 assigned
NOW function
system date
system time
Click the OK button
(Function Arguments
dialog box) to display
the system date and
time in the selected
cell, using the default
date and time format
mm/dd/yyyy hh:mm.
shortcut menu
Right-click cell I11
Format Cells
command
to display a shortcut
menu and Mini
toolbar (Figure 3 – 22).
Why does the date
appear with the
mm/dd/yyyy hh:mm
format?
Excel automatically formats the result of the NOW function as a date, using the date and
time format, mm/dd/yyyy hh:mm, where the i rst mm is the month, dd is the day of the
month, yyyy is the year, hh is the hour of the day, and mm is the minutes past the hour.
Figure 3 – 22
 
Search JabSto ::




Custom Search