Returns the specified value as a string based on the current NumberFormat property setting. Read-only String.
expression.Text
expression Required. An expression that returns one of the above objects.
Text property as it applies to the 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.
expression.Text
expression Required. An expression that returns a Range object.
Example
This example sets a variable for the formatted value of cell A1.
txt = Spreadsheet1.Range("a1").Text