TEXT function

Category: Text
Introduced: Excel 2003

Summary

Formats a number and converts it to text

Syntax

TEXT(value, format_text)

Example

=TEXT(Value you want to format, "Format code you want to apply")

Microsoft Support Page

https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c

Back to Functions