Microsoft Office Tutorials and References
In Depth Information
It Takes All Types
Suffice to say that you can foul up your formulas but good if they refer to any
cells containing text where Excel expects values to be.
The telltale signs of text
A text entry is simply an entry that Excel can’t pigeonhole as either a
formula or value. This makes text the catchall category of Excel data types. As a
practical rule, most text entries (also known as labels ) are a combination of
letters and punctuation or letters and numbers. Text is used mostly for titles,
headings, and notes in the worksheet.
You can tell right away whether Excel has accepted a cell entry as text
because text entries automatically align at the left edge of their cells. If the
text entry is wider than the cell can display, the data spills into the
neighboring cell or cells on the right, as long as those cells remain blank .
If, sometime later, you enter information in a cell that contains spillover text
from a cell to its left, Excel cuts off the spillover of the long text entry (see
Figure 2-3). Not to worry: Excel doesn’t actually lop these characters off the
cell entry — it simply shaves the display to make room for the new entry. To
redisplay the seemingly missing portion of the long text entry, you have to
widen the column that contains the cell where the text is entered. (To find
out how to do this, skip ahead to Chapter 3.)
cells to the
right cut off
text in cells
on the left.