PRECISION

Macro Sheets Only

Equivalent to selecting or clearing the Precision As Displayed check box in the Calculation tab of the Options dialog box, which appears when you choose the Options command from the Tools menu. Controls how values are stored in cells. Use PRECISION when the results of formulas do not seem to match the values used to calculate the formulas.

Syntax

PRECISION(logical)

Logical is a logical value corresponding to the Precision As Displayed check box in the Calculation tab.

Caution The PRECISION function may permanently alter your data. PRECISION(FALSE) causes Microsoft Excel to change values on your worksheet or macro sheet to match displayed values. PRECISION(TRUE) causes Microsoft Excel to store future values at full precision, but it does not restore previously entered numbers to their original values.

Remarks

Related Functions

FORMAT.NUMBER Applies a number format to the selection

WORKSPACE Changes workspace settings

List of Command-Equivalent Functions