What-If Analysis, Charting, And Working With Large Worksheets Page 25
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 161
Format Cells
3
dialog box
•
Click Format Cells on the shortcut
menu to display the Format Cells
dialog box.
Number tab
•
If necessary, click the Number tab
(Format Cells dialog box) to display
Sample of system
date in cell I11 using
the Number sheet.
selected format
Date category
•
Click Date in the Category list (Format
Cells dialog box) to display the types
of date formats in the Type list. Scroll
desired format type
down in the Type list and then click
3/14/2001 to display a sample of the
data in the active cell, I11 in this
case, using the selected format in
the Sample area (Figure 3–23).
Why do the dates in the Type box
show March 14, 2001 instead of the
current date?
The date March 14, 2001 is used as
OK button
a sample date in the Format cells
dialog box.
Figure 3–23
4
•
Click the OK button (Format Cells
dialog box) to display the system
date in the format mm/dd/yyyy.
Excel displays
system date with
•
Double-click the border between
mm/dd/yyyy format
columns I and J to change the
width of the column to best fi t
(Figure 3 – 24).
How does Excel format a date?
In Figure 3 – 24, the date is displayed
Figure 3 – 24
right-aligned in the cell because
Excel treats a date as a number formatted to display as a date. If you assign the General
format (Excel’s default format for numbers) to a date in a cell, the date is displayed as
a number with two decimal places. For example, if the system time and date is 9:00 AM
on November 13, 2012 and the cell containing the NOW function is assigned the General
format, then Excel displays the following number in the cell:
41226.375
Other Ways
Number of days since
Time of day is 9:00 AM
1. Click Date & Time
December 31, 1899
(Portion of day complete)
(Formulas tab | Function
click
Library group),
The whole number portion of the number (41226) represents the number of days since
now
December 31, 1899. The decimal portion of the number (.375) represents 9:00 AM as the
+
2. Press
CTRL
SEMICOLON
(not a volatile date)
time of day, at which point 37.5% of the day is complete. To assign the General format to
+
+ #
3. Press
CTRL
SHIFT
a cell, click General in the Category list in the Format Cells dialog box (Figure 3 – 23).
to format date to
day-month-year
If you wish to stop working through the chapter at this point, you can quit Excel now and then resume the
Break Point:
project at a later point in time by starting Excel, opening the fi le called Modern Music Shops Six-Month Financial Projection,
and continuing to follow the steps from this location forward.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education