Range.Text Property

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:

• Range Object
• Range Object Members