The Easiest way to add text to a formula in excel

August 5, 2022
260 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

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.

Result

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.

Result

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.

Result

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.

You can also download WPS office to edit the word documents, excel, PowerPoint for free of cost. To get an easy and enjoyable working experience download WPS Office now!!

Was this helpful?

Yes

No