Share via

Range.Text Property (Excel)

Returns or sets the text for the specified object. Read-only String.


expression .Text

expression A variable that represents a Range object.


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

See Also


Range Object Members

Range Object