Excel Function

TEXT

Formats value as text using a format code.

TEXT(value, format_text)

Arguments

value

Required

Specify a single cell reference.

format_text

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

Use TEXT to convert cell D2 (Payment Amount in column D) to text using the format "#,##0".

Example Table

#
AEmployee ID
BName
CEmail
DPayment Amount
EAmount Text
2E001Taro Tanakat.tanaka@example.com12001200
3E002Hanako Suzukih.suzuki@example.com980980
4E003Ken Satok.sato@example.com24502450
5E004Aya Takahashia.takahashi@example.com30003000
6
7
8

How to Use (Formula)

=TEXT(D2, "#,##0")

Result

1,200

Practice This Function

Start Function PracticeBack to Function List

TEXT FAQ

How do I use TEXT in Excel?

Use TEXT when you want to format numbers or dates as display text. Enter Value, Format text in that order, then add optional arguments when needed.

Where can I practice TEXT?

Use the "Start Function Practice" button to jump straight into TEXT drills.

What arguments does TEXT use?

The main arguments are Value, Format text. Enter them in order.