Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Entering Values

The procedure for entering values is identical to the procedure for entering labels. After you select the cell in which you want to enter the value, simply begin typing. As with labels, the values you type appear both in the cell and in the Formula bar.

Excel treats numbers and text differently. For one, values are aligned automatically with the right edge of the cell. Values are displayed in Excel's General number format. However, you can always change or customize the alignment, appearance, and formatting of numbers in the worksheet. If a value is too wide to fit in the current width of a cell, Excel displays a series of # characters, as shown in Figure 2.5, across the width of the cell to let you know that the number cannot ...