Class ModelFormatDecimalNumber (Excel VBA)

The class ModelFormatDecimalNumber represents the format to be used for a model measure in the data model.


To use a ModelFormatDecimalNumber class variable it first needs to be instantiated, for example

Dim mfd as ModelFormatDecimalNumber
Set mfd = ActiveWorkbook.Model.ModelFormatDecimalNumber

ModelFormatDecimalNumber class variables can be set using the Model.ModelFormatDecimalNumber procedure.


Specifies the number of decimal places after the dot.

ActiveWorkbook.Model.ModelFormatDecimalNumber.DecimalPlaces =


Specifies whether to display commas between thousands.

ActiveWorkbook.Model.ModelFormatDecimalNumber.UseThousandSeparator = True