Free All-in-One Office Suite with PDF Editor

Edit Word, Excel, and PPT for FREE.

Read, edit, and convert PDFs with the powerful PDF toolkit.

Microsoft-like interface, easy to use.

Windows • MacOS • Linux • iOS • Android

# TEXT formula in WPS Spreadsheet

Uploaded time: August 27, 2021 Difficulty Beginner

# TEXT formula in WPS Spreadsheet

TEXT formula in WPS Spreadsheet

The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice.

Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, enteredcell A2. How can we convert it into a value with only three decimal places?

1. Select cell C2.

2.Click **Insert Function** in the **Formula** tab, and choose the TEXT formula from the popup dialog.

This step can insert the TEXT formula into cell C2. Here **Value**corresponds to the number in A2, while the **Format_text** data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/faae5f1b3afe1ec53f79a8cae113000e.gif" data-test="skks"
style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720));
text-align:center;" >

In this example, select cell A1 when the **Value** box is in editing status. Then, enter 0.000 as the target format in the **Format_text** box, which means the target value will present as a number with three decimal places.Note that quotation marks are needed if we want the target value to present as pure text contents. Finally, click **OK** to get the target value 2.013.

Here is another case. If we want to convert the value of cell A3 into a percentage with three decimal places, the same format as 0.000%, the TEXT formula can also be helpful.

1. Click the **Insert function** button, and insert the TEXT formula.

2. Fill the **Value** box by selecting cell A3.

3. Enter 0.000% in the **Format_text** input box, and click **OK** to get the result.

Similarly, we can run the TEXT formula to indicate days of the week for the exact date. For instance, the result indicates that it is Wednesday on September 1st, 2021. To realize it, click the **Insert function** button, and insert the TEXT formula. Then, enter the following parameter into the corresponding input box: A4 in the **Valu****e** input box and dddd in the **Format_text** box. Here dddd stands for days of the week. After these, click **OK** to run the formula.

Here comes the end of the introduction to the TEXT formula. A list of functions of the TEXT formula is presented on the screen. You can also download relevant materials for practice from the link added in the description box of this video.

Does this video help you?