Microsoft Office Tutorials and References
In Depth Information
Entering Numbers
Entering Numbers
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 special characters is
explained when they are used in this topic.
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Enter Numbers
The Personal Budget Worksheet numbers used in Chapter 1 are summarized in Table 1– 1. These
numbers, which represent yearly income and expenses amounts, must be entered in rows 4–5 and 9–16.
Table 1– 1 Personal Budget Worksheet
Income
January
February
March
April
May
June
July
August
September
October
November
December
Wages
1000.29
1000.29
1000.29 1000.29
1000.29
1000.29
1000.29
1000.29
1000.29
1000.29
1000.29
1000.29
Dividends
4000.75
0
0
0
0
0
0
0
4000.75
0
0
0
Expenses
January
February
March
April
May
June
July
August
September
October
November
December
Rent
400.89
400.89
400.89
400.89
400.89
400.89
400.89
400.89
400.89
400.89
400.89
400.89
Food
300
300
300
300
300
300
300
300
300
300
300
300
Tuition
1500
0
0
0
0
0
0
1500
0
0
0
0
Books
500
0
0
0
0
0
0
500
0
0
0
0
Entertainment
100
100
100
100
100
100
100
100
100
100
100
100
Car Payment
154.79
154.79
154.79
154.79
154.79
154.79
154.79
154.79
154.79
154.79
154.79
154.79
Gas
100
100
100
100
150
150
150
100
100
100
100
100
Miscellaneous
100
100
100
100
100
100
100
100
100
100
100
100
The following steps enter the numbers in Table 1– 1 one row at a time.
1
Tap or click cell B4 to
select it.
Type 1000.29
and then if you are
using a touch screen,
tap cell C4. If you are
using a mouse, press
the RIGHT ARROW key
to enter the data
in the selected cell
and make the cell
to the right (cell C4)
the active cell
(Figure 1–14).
cell C4 is
active cell
1000.29 entered
in cell B4
Figure 1– 14
Do I need to enter
dollar signs, commas, or trailing zeros for the 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