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

Entering Text

Text is any combination of letters, numbers, and spaces. By default, text is automatically left-aligned in a cell, whereas numerical data is right-aligned.

Entering Numbers As Text To enter a number that you want treated as text (such as a ZIP code), precede the entry with a single quotation mark ('), as in '46220. The single quotation mark is an alignment prefix that tells Excel to treat the following characters as text and left-align them in the cell. You do not have to do this to “text” numerical entries, but it ensures that they will not be mistakenly acted upon by formulas or functions.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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