• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 8. Changing the Appearance of Text > Treating Numbers Like Text

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.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint