TEXT

Try it

When to use it

What does TEXT do?

TEXT converts a number or date into text formatted by a pattern you supply, such as a currency, percentage, or date layout. The result is text, not a number.

When should I avoid TEXT?

Avoid TEXT when you still need to do math on the value. Formatting turns the number into text, so apply TEXT only at the point where you want a display string.

Use cases

Show a ratio as a percentage

Format a large number with thousands separators

Used in

retail · operations

Syntax

TEXT(value, format)