The Easiest way to add text to a formula in excel
A free Office suite fully compatible with Microsoft Office
WPS excel is being popular among the business people, accountants, managers, even management students because of its compatibility, easy to use and free of cost version. Add text to a formula in excel is used to convert the number-to-text in a certain format in WPS excel or spreadsheet.
Add text to a formula in excel is used to customized cell format for actual uses. It doesn't matter whether you are using WPS excel 2016/2019/mac/online the procedure is the same to add text to a formula.
Here we will illustrate how to add text to a formula in excel with picture demonstration.
Add text to formula to convert a value to 3 decimal places
Let, a number 2.01234567 is to be converted into 3 decimal places. We need to adjust the second parameter of the formula, Format_Text.
Step-1: select the cell C2 where the result will be shown.
Step-2: Got to formula tab and at the left click insert function, then choose TEXT formula from the popup window.
Select TEXT formula
Step-3: Now it's time to insert the parameter. The value corresponds to the number in cell A2 and the Format_text is for the expected format for the value. Here, we insert '0.000' to indicate 3 decimal places.
Insert Text to formula.
Step-4: Click ok and the result will be shown in text format. Remember, the 0.000 must be placed in double quotation for pure text format.
Add text to a formula to convert into percentage with 3 decimal places
Now, if we want to convert the value 0.02123456 into a percentage value keeping 3 decimal places and a text format,
Step-1: Select C3 cell and go to the formula tab and from the left corner click insert function and select TEXT.
Select Text Formula
Step-2: In the function arguments window fill the ‘Value’ by selecting A3 cell. And at the 'Format_text' insert '0.000%' which will convert the number in cell A3 into a percentage value keeping 3 decimal places.
Insert Text to formula
Step-3: Click 'ok' and you will find the result in C3 cell.
Add text to convert a date into a week
We can add the text formula to indicate a date into day of the week.
Step-1: Select C4 cell and in the formula tab, click insert function and select text.
Select Text Formula
Step-2: In the function arguments window fill the ‘Value’ by selecting A4 cell. And at the 'Format_text 'insert ' dddd' which will convert the date in cell A4 into the day of the week as a text content.
Insert text to convert date into day
Step-3: Click 'ok' and the result will be shown in C4 cell.
If you have reached here, we hope you have learned the easiest way to add text to a formula in excel. We hope you have found it easy to insert signature in word.
For more information about WPS word, please follow WPS academy to learn about it.
Was this helpful?