WorksheetFunction.Text(Object, String) Method

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Converts a value to text in a specific number format.

public:
 System::String ^ Text(System::Object ^ Arg1, System::String ^ Arg2);

public string Text (object Arg1, string Arg2);

Public Function Text (Arg1 As Object, Arg2 As String) As String

Parameters

Arg1

Object

A numeric value, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value.

Arg2

String

A number format in text form in the Category box on the Number tab in the Format Cells dialog box.

Returns

String