Thousands Property [LabelFormat]

 

The Thousands property returns or sets the label thousands separator. Returns a Boolean.

 

Syntax

object.Thousands

object.Thousands = Thousands

 

Parameter

Type

Description

Thousands

Boolean

required; true to use thousands separators

 

Example 1

This example returns the state of the thousands style.

 

Debug.Print LabelFormat.Thousands

 

Example 2

This example demonstrates how to display the thousands separator in labels.

 

LabelFormat.Thousands = True

 

Used by: LabelFormat object