What it does: The TEXT() function takes a text input and formats the text according to format you select.

Plain English: Many times, you’ll encounter incorrectly formatted data that you need to clean up for your projects; numbers formatted as text, dates formatted as strings, etc.. This function helps you clean up the “noise.”

Arguments: TEXT(string,format)

• String – The string you want to format.
• Format – The format you want to change the string to.