690
Chapter 25 Advanced Worksheet Formatting
Excel 2003. If you format the cells first, then apply the Text format, and finally enter the
numbers, Excel treats the data as text, just as you intended. However, if you try to apply the
Text format to numbers that are already in your worksheet, Excel changes the alignment of
the cell, but not the data stored there. After applying the Text format, you must click in each
reformatted cell, press F2, and then press Enter to store the number as text. The new error-
checking tools in Excel 2003 do not identify cells formatted this way, either.
If you format a cell as text and enter a formula in that cell, you ...