There are numerous ways to express a number. A number can be expressed as a whole number, as a percent, as a fraction, as currency, as a date, and even exponentially. Google Spreadsheets employs a wide variety of number formats that you can apply to your data. Table 5 details the number formats available in Google Spreadsheets; Table 6 details the percent formats; Table 7 details the date and time formats. Examples are included for each.
Note The difference between the plain text and normal formats is in the alignment. The plain text format is left aligned; the normal format, as with all the other number formats, is right aligned. Google Spreadsheets applies the Normal number format by default when you enter numbers into your worksheet. You can, however, apply any number format to any particular cell. To apply a different number format, follow these steps:
Figure 29. Choosing a number format.
|