Use these procedures to set up units in Results Connect.
To set up units for the active workbook
- Click Results Connect tab Tools panel Units.
The Units dialog opens.
- Select Active workbook Units.
The selected measurement system displays in the Units dialog for the active workbook.
- Select a unit category, and then specify a measurement unit for it.
Tip: Click the unit to expand all available units for the selected category.
- Optionally:
- Select Custom, Imperial, or Metric as the measurement system from the Reset current units to... drop-down list, if you want to change the current units for the active workbook.
- Select Show used units only if you want to display the units which are used in the existing formulas.
- Select Use the original values in formulas if you want to use the original values in the project.
- Click OK.
To set up units for the selected measurement system
- Click Results Connect tab Tools panel Units.
The Units dialog opens.
- Select Units settings Custom, Imperial, or Metric.
The selected measurement system displays in the Units dialog.
- Select a unit category, and then specify a measurement unit for it.
Tip: Click the unit to expand all available units for the selected category.
- Optionally:
- Select Save the current units as the default for new workbooks if you want to save the current measurement system as the default.
- Select Show used units only if you want to display the units which are used in the existing formulas.
- Select Use the original values in formulas if you want to use the original values in the project.
- Click OK.
Note: You can also use the Fixed unit option from the Formula wizard dialog to change the current unit directly while inserting the formula in the worksheet. This option is only available for some of the formulas.