Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.Text Method (Excel)

Published: July 16, 2012

Converts a value to text in a specific number format.

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

Community Additions

ADD
Show:
© 2014 Microsoft