DEFINITION: The TEXT function allow you to change the way a number display by applying formatting to it with format rule. It is useful in lots of situations where you need to display numbers in a more readable format accordingly, or you want to combine numbers with text or symbols. Specially it useful to extract or format a date according to your need.
