Format Numbers

You can use a variety of formatting features to change a number’s appearance. Use the Number Group on the Formatting Palette to do the following:

  • choose a category of number (currency, percentage, date, etc.)
  • choose a style (decimals, commas, etc.)

To format a number or a series of numbers:

  • Select the cell(s) to configure.
    format
  • Navigate to the Formatting Palette/Number Group.
  • Select the appropriate Category in the drop-down menu.
  • The changes will appear in the selected cells.

To change formatting options or formatting styles:

  • Select the Cells to be formatted.
  • At the top of the screen, click on the Format menu, and select Cells…
  • The Formatting Window appears.
  • Make the appropriate changes, and press OK.