Microsoft Office Tutorials and References
In Depth Information
Entering Numbers
Numeric Limitations
In Excel, a number can be
between approximately –1
×
Entering Numbers
10308. This
means it can be between
a negative 1 followed by
308 zeros and a positive
1 followed by 308 zeros.
To enter a number such
as 6,000,000,000,000,000,
you can type
6,000,000,000,000,000, or
you can type 6E15, which
translates to 6
10308 and 1
×
In Excel, you can enter numbers into cells to represent amounts. A number can contain
only the following characters:
0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e
If a cell entry contains any other keyboard character (including spaces), Excel
interprets the entry as text and treats it accordingly. The use of the special characters is
explained when they are used in this topic.
×
1015.
To Enter Numbers
The Save Sable River Foundation Lifetime Fundraising Summary numbers used in Chapter 1 are summarized
in Table 1–1. These numbers, which represent lifetime fundraising amounts for each of the fundraising activities and
cities, must be entered in rows 4, 5, 6, 7, and 8.
Table 1 – 1 Save Sable River Foundation Lifetime Fundraising Summary
Allentown
Chamber City
Pattonsville
Sable Village
Strongville
Town of Cary
Corporate
74029.35
92278.21
63081.74
84210.02
61644.26
89820.51
Direct Mail
67286.06
83867.23
55076.48
55547.28
79779.02
84366.19
Fun Runs
54704.39
66934.67
64581.66
28895.86
32690.37
64242.72
Government
30623.99
58614.35
51486.46
36387.09
51642.55
40177.87
Phone-a-thon
16692.14
24223.81
9492.91
17328.74
12305.85
21097.60
The following steps enter the numbers in Table 1–1 one row at a time.
1
Click cell B4 to select it.
Type
74029.35
and then press the
RIGHT ARROW key to
enter the data in
the selected cell and
make the cell to the
right the active cell
(Figure 1–15).
C4 is active cell
74029.35 entered
in cell B4
Figure 1–15
Do I need to enter dollar signs, commas, or trailing zeros for the fundraising summary
amounts?
You are not required to type dollar signs, commas, or trailing zeros. When you enter a
dollar value that has cents, however, you must add the decimal point and the numbers
representing the cents. Later in this chapter, the numbers will be formatted to use dollar
signs, commas, and trailing zeros to improve the appearance and readability of the numbers.
Search JabSto ::




Custom Search