Thousands Property [WksCellFormat]

 

The Thousands property 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 variant.

 

Syntax

object.Thousands

object.Thousands = Thousands

 

Parameter

Type

Description

Thousands

Boolean

required; true to use thousands separators

 

Example

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

 

Debug.Print WksCellFormat.Thousands

 

Used by: WksCellFormat object