Thousands Property [WksCellFormat]

Thousands returns or sets whether numbers are formatted with thousands separator characters. A null is returned if all the cells in a range do not have the same thousands separator formatting. Returns a Boolean. When this is 'True', a comma appears every three digits to the left of the decimal point. When this is 'False', the number appears without the comma every three digits.

Syntax

object.Thousands

object. Thousands = Thousands

Parameter	Type	Description
Thousands	Boolean	required

Example

This example demonstrates how to return whether or not a cell uses a thousands separator.

Debug.Print WksCellFormat.Thousands

Used by: WksCellFormat object