Class ModelFormatDecimalNumber (Excel VBA)

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

Item

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.

DecimalPlaces

Specifies the number of decimal places after the dot.

ActiveWorkbook.Model.ModelFormatDecimalNumber.DecimalPlaces =

UseThousandSeparator

Specifies whether to display commas between thousands.

ActiveWorkbook.Model.ModelFormatDecimalNumber.UseThousandSeparator = True