Class ModelFormatWholeNumber (Excel VBA)

The class ModelFormatWholeNumber represents the format to be used for a model measure in the data model. To use a ModelFormatWholeNumber class variable it first needs to be instantiated, for example

Dim mfw as ModelFormatWholeNumber
Set mfw = ActiveWorkbook.Model.ModelFormatWholeNumber

UseThousandSeparator

Specifies whether to display commas between thousands.

ActiveWorkbook.Model.ModelFormatWholeNumber.UseThousandSeparator = True