Question

what is the function oftext formulas??

Answer 1

Answer:

The Excel TEXT Function is used to convert numbers to text within a spreadsheet. Essentially, the function will convert a numeric value into a text string. TEXT is available in all versions of Excel.

Answer 2

Answer:

The TEXT function returns a number formatted as text. 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.