Text Property

         Example         Applies To

PivotAggregate or PivotDetailCell object: Returns the specified value as a string based on the current NumberFormat property setting. Read-only String.

Range object: Returns the formatted value displayed in the specified cell. Returns Null if the range includes more than one cell and the cells do not all contain the same value. Use the IsNull function to determine whether the return value is Null. Read-only Variant.