CB.FormatPrefsND Example 1

This example selects a forecast cell, turns off the underlying cell format preference in case it is on, and then changes the format of the axis labels to be a fixed number of decimal places: 3.

Range("B7").Select
cb.FormatPrefsND cbFmtUnderlying, False
cb.FormatPrefsND cbFmtFormatType, cbFttFixed
cb.FormatPrefsND cbFmtDecimalPlace, 3