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

Entering Numbers

Valid numbers can include the numeric characters 0–9 and any of these special characters: + - / . , $ %. This means that you can include commas, decimal points, dollar signs, percent signs, and parentheses with the numbers that you enter into your worksheet.

Although you can include punctuation when you type your entries, you may not want to. For example, instead of typing a column of dollar amounts complete with dollar signs, commas, and decimal points, you could type just the numbers, such as 700 and 81295, and then format the column with currency formatting. Excel would then change your entries to $700.00 and $81,295.00 or to $700 and $81295, depending on the number of decimal points you specify. By not entering the dollar signs, commas, and decimal points yourself, you save time and give yourself the ability to change the format later on if you like. See Lesson 21 for more information on how to format numbers.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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