How to use the Excel TEXT function | Exceljet
The TEXT function is especially useful when you want to embed a number inside text with a certain format. For example, "Sales last year increased by over $43,500", where the number 43500 has been formatted with a currency symbol and thousands separator. Examples. Below are examples of the TEXT function used to format a value in A1:
GET PRICE >>