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

Chapter 4. Formatting Your Worksheets > Mastering Number Formats

Mastering Number Formats

When you enter a number in Excel, it's entered as a plain number-25, for example. But that number can mean different things. For example, does 25 mean $25, .25, or 25%? The way you format a number changes its meaning. In your worksheet, you need to apply the appropriate number format so that the meaning of the numbers is clear.

The formatting of a number is called a style. By default, Excel assigns the General style to number entries, which has no specified formatting. There are ten other number styles you can apply to convey the meaning of values in a cell or range. You can also create your own number format to apply (see "Creating Custom Number Formats," later in this chapter). Table 4.2 lists each of the number styles you can use.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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