Microsoft Office Tutorials and References
In Depth Information
Entering Numbers
2
Repeat Step 1 to enter the remaining
row titles in column A; that is, enter
Mini in cell A5, Micro in cell A6,
Flash in cell A7, Accessories
in cell A8, and Total in cell A9
(Figure 1–28).
Why is the text left-aligned in the cells?
When you enter text, Excel
automatically left-aligns the text in
the cell. Excel treats any combination
of numbers, spaces, and nonnumeric
characters as text. For example, the
following entries are text:
row titles
left-aligned
in cells
401AX21, 921-231, 619 321, 883XTY
You can change the text alignment
in a cell by realigning it. Several
alignment techniques are discussed
later in the chapter.
Figure 1–28
Entering Numbers
Numeric Limitations
In Excel, a number can be
between approximately
–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.
10 308 and 1
10 308 ,
that is, 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
stands for 6
10 15 .
 
 
Search JabSto ::




Custom Search