Text Property
TOC
Collapse the table of content
Expand the table of content

Range.Text Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Concepts

Other resources

Show:
© 2016 Microsoft