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