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:
- Enter only the values in the cells. Do not enter the measurements.
- Press Ctrl and select the cells.
- Click tab and select Custom in
the Category field.
- In the Format code field, enter a number
sign (#) and the measurement within double quotation marks. For example,
if you want to add m³ to the cells you selected,
enter #"m³" in the Type field.
- Click OK to add the measurement.
IBM® Lotus® Symphony™ Spreadsheets
To
add measurements for multiple cell values, do the following steps:
- Enter only the values in the cells. Do not enter the measurements.
- Press Ctrl and select the cells.
- Right-click the cells and click tab.
Select User-defined in the Category field.
- In the Format code field, enter a number
sign (#) and the measurement within double quotation marks. For example,
if you want to add m³ to the cells you selected,
enter #"m³" in the Type field.
- Click the Add icon on the right of the Format
code field.
- Click OK to add the measurement.