CalculatedMember.NumberFormat (Excel)

Returns an XlCalcMemNumberFormatType value that represents the number format of the calculated member. The default value is xlNumberFormatTypeDefault. Possible return values are xlNumberFormatTypeDefault - Use the default format type of the calculated member for the cell value, xlNumberFormatTypeNumber - Calculated member cell format is a number, xlNumberFormatTypePercent - Calculated member cell format is a percentage.

Dim xcmNumberFormat As XlCalcMemNumberFormatType
xcmNumberFormat = ActiveCell.PivotTable.CalculatedMembers(1).NumberFormat