Without the TEXT function, the number formatting will be stripped. 15 has been formatted with a percent symbol. For example, 'Sales last year increased by over 15%', where the number. One example is when you want to concatenate (join) a formatted number to text. Normally, you want to maintain numeric values in Excel, because they can be used in formulas that perform numeric calculations. However, there are situations where converting numbers to text makes sense.
