TEXT function in Excel and Google Sheets

Formula, examples, and how to use it

The TEXT function lets you convert a number into a text string. =TEXT(Value you want to format, "Format you want to apply").

Why is the TEXT Function required?

TEXT function becomes handy especially when you have CONCATENATE/combine number and a text, for example, the 10% are stored as 0.1 in Excel or Google Sheets and this is where you would force to display as 10% with TEXT formula.

Check below for various TEXT function and formula examples