IBM Lotus Symphony


Setting a number format

You can specify the formatting options for numbers in a cell in Number Format section of the Properties panel. The Number Format section is enabled when you select one or more cells in IBM® Lotus® Symphony™ Spreadsheets.

  1. Select one or more cells for which you want to edit the number format.
  2. Set a number format in the Number Format section of the Properties panel.
    1. Select a number category from the Category list. Or you can click the icons to quickly define the category.
      Table 1. Icons for defining a category
      Icon Category
      Number Number
      percent Percent
      currency Currency
      date Date
      text Text
    2. Enter the number of zeros that you want to display after the decimal point in the Decimal places field.
    3. Enter the number of zeros that you want to display in front of the decimal point in the Leading zeros field.
    4. Select the Negative numbers red check box to change the font color of the negative numbers to red.
    5. Select the Thousands separator check box to insert a separator between thousands.
    Note: You can perform steps b, c, d, and e only if you select General, Number, Percent, or Currency from the Category list in step a.
  3. Optional: Click the More options icon More in the upper-right corner of Number Format section to open the Numbers tab in the Text and Cell Properties window. You can set other properties, such as language settings.

Product Feedback | Additional Documentation | Trademarks