The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.. This function is categorized as a String/Text Function.
In this video we described how to use TEXT function in different situations.