Digits Property

The Digits property returns or sets the number of digits to the right of the decimal point. Returns a null if all the cells in a range do not have the same number of decimal digits. Returns a Variant.

Syntax

object.NumDigits

object.NumDigits = NumDigits

 

Parameter	Type	Description
NumDigits	Integer	required, number of digits after decimal point

 

Example 1

This example demonstrates how to return the number of digits after the decimal point.

Debug.Print WksCellFormat.Digits

Example 2

This example demonstrates how to change the number of digits after the decimal point to three.

WksCellFormat.Digits = 3

 

Used by: WksCellFormat object