PrecisionAsDisplayed Property Example
This example causes calculations in the active workbook to use only the precision of the numbers as they’re displayed.
ActiveWorkbook.PrecisionAsDisplayed = True