IBM Lotus Symphony


Adding measurements for multiple cell values

This section describes a convenient way to add measurements when your data is large.

Microsoft® Excel 2003

To add measurements for multiple cell values, do the following steps:
  1. Enter only the values in the cells. Do not enter the measurements.
  2. Press Ctrl and select the cells.
  3. Click Format > Cells > Number tab and select Custom in the Category field.
  4. In the Format code field, enter a number sign (#) and the measurement within double quotation marks. For example, if you want to add to the cells you selected, enter #"m³" in the Type field.
  5. Click OK to add the measurement.

IBM® Lotus® Symphony™ Spreadsheets

To add measurements for multiple cell values, do the following steps:
  1. Enter only the values in the cells. Do not enter the measurements.
  2. Press Ctrl and select the cells.
  3. Right-click the cells and click Text and Cell Properties > Number tab. Select User-defined in the Category field.
  4. In the Format code field, enter a number sign (#) and the measurement within double quotation marks. For example, if you want to add to the cells you selected, enter #"m³" in the Type field.
  5. Click the Add icon on the right of the Format code field.
  6. Click OK to add the measurement.

Product Feedback | Additional Documentation | Trademarks