At first glance, the TEXT function may not sound very useful. Here are a few simple applications.
In the top example, without the TEXT function, the total is not formatted correctlt (as a currency). However, the TEXT function allows us to apply the correct format to the number component of the string.
In the second example, we see how the TEXT function allows us to reformat existing data – such as dates.