TEXT function

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Applies To

SharePoint Server Subscription Edition SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint in Microsoft 365 SharePoint Foundation 2010 SharePoint Server 2010 SharePoint in Microsoft 365 Small Business Windows SharePoint Services 3.0

Converts a value to text in a specific number format.

Syntax

TEXT(value,format_text)

Value is a numeric value, a formula that evaluates to a numeric value, or a column reference containing a numeric value.

Format_text is a number format in text format.

Remark

Using the TEXT function converts a value to formatted text, and the result is no longer calculated as a number.

Examples

Salesperson	Sales	Formula	Description (Result)
Buchanan	2800	=[Salesperson]&" sold "&TEXT([Sales], "$0.00;($0.00)")&" worth of units."	Combines contents into a phrase (Buchanan sold $2,800.00 worth of units.)
Dodsworth	.4	=[Salesperson]&" sold "&TEXT([Sales],"0.00%")&" of the total sales."	Combines contents into a phrase (Dodsworth sold 40.00% of the total sales.)