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
Calculations use precision as displayed in report. Can I force Excel to calculate using the numbers shown in the spreadsheet? precision Precision as displayed Precision As Displayed Property precisionas Precisionasdisplayed PrecisionAsDisplayed Property Use numbers as shown in math

See also: