Thousands Property

The Thousands property returns if numbers are formatted with thousands separator characters. A null is returned if all the cells in a range or label do not have the same thousands separator formatting. Returns a Boolean.

Syntax

object.Thousands

Example 1

This example demonstrates how to return if a label uses a thousands separator.

Debug.Print LabelFormat.Format.Thousands

Example 2

This example demonstrates how to return if a cell uses a thousands separator.

Debug.Print WksCellFormat.Thousands

 

Used by: AutoLabelFormat object, WksCellFormat object