TEXT

Converts a number or date to text with a specified format. Solves the common problem of dates displaying as serial numbers or numbers losing their formatting when concatenated.

Syntax

excel-mastery

=TEXT(value, format_text)

Example

excel-mastery

=TEXT(TODAY(), "MMMM YYYY")

="Report for "&TEXT(A2, "MMMM D, YYYY")

=TEXT(Revenue, "$#,##0.00")