Share via


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

See Also

Concepts

Range Object Members

Range Object