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