WorksheetFunction.Text Method

Excel Developer Reference

Converts a value to text in a specific number format.

Syntax

expression.Text(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

Name	Required/Optional	Data Type	Description
Arg1	Required	Variant	A numeric value, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value.
Arg2	Required	String	A number format in text form in the Category box on the Number tab in the Format Cells dialog box.

Return Value
String

See Also

• WorksheetFunction Object
• WorksheetFunction Object Members