Digits Property

Digits returns or sets the number of decimal digits. Returns a null if all the cells in a range do not have the same number of decimal digits. Returns a variant.

Syntax

object.Digits

object.Digits = Digits

Parameter

Type

Description

Digits

short

required

Example 1

This example demonstrates how to return the number of digits displayed in a cell.

Debug.Print WksCellFormat.Digits

Example 2

This example demonstrates how to set the number of digits displayed in a cell to four.

WksCellFormat.Digits = 4

Used by: WksCellFormat object