Range.Text Property (Excel)
Returns or sets the text for the specified object. Read-only String.
Syntax
expression .Text
expression A variable that represents a Range object.
Example
This example illustrates the difference between the Text and Value properties of cells that contain formatted numbers.
Set c = Worksheets("Sheet1").Range("B14")
c.Value = 1198.3
c.NumberFormat = "$#,##0_);($#,##0)"
MsgBox c.Value
MsgBox c.Text