O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Treating Numbers Like Text

Excel evaluates each of your entries and determines whether the entry is a value or label. A mixed cell entry that contains both values and text is automatically treated like a label. For example, an address like 1750 Clint Moore Road is treated like a label.

A mixed cell entry that contains numbers and text cannot be used as part of a calculation.

You can also enter numbers in a cell and have Excel treat the entry as a label. You might want to consider telephone numbers, ZIP Codes, and invoice numbers as labels instead of values. Whenever you want Excel to treat a numeric cell entry as a text, preface the entry with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required