Applies ToSharePoint Server Abonelik Sürümü SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise Microsoft 365’te SharePoint SharePoint Foundation 2010 SharePoint Server 2010 Microsoft 365 Küçük İşletme’de SharePoint 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.)

Daha fazla yardıma mı ihtiyacınız var?

Daha fazla seçenek mi istiyorsunuz?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.