Workbook.PrecisionAsDisplayed Property

Excel Developer Reference

True if calculations in this workbook will be done using only the precision of the numbers as they’re displayed. Read/write Boolean.

Syntax

expression.PrecisionAsDisplayed

expression   A variable that represents a Workbook object.

Example

This example causes calculations in the active workbook to use only the precision of the numbers as they’re displayed.

Visual Basic for Applications
  ActiveWorkbook.PrecisionAsDisplayed = True

See Also