Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link