Class ModelFormatScientificNumber (Excel VBA)

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

Item

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

Dim mfs as ModelFormatScientificNumber
Set mfs = ActiveWorkbook.Model.ModelFormatScientificNumber

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

DecimalPlaces

Specifies the number of decimal places after the dot.

ActiveWorkbook.Model.ModelFormatScientificNumber.DecimalPlaces =