Microsoft Office Tutorials and References
In Depth Information
• 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
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:
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.
In Excel, a number can be
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
you can type
you can type 6E15, which
stands for 6
10 15 .