Microsoft Office Tutorials and References
In Depth Information
In Excel, a number can be
between approximately –1
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
you can type
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.
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
Town of Cary
The following steps enter the numbers in Table 1–1 one row at a time.
Click cell B4 to select it.
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
C4 is active cell
in cell B4
Do I need to enter dollar signs, commas, or trailing zeros for the fundraising summary
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.