How to convert text to number in WPS Office Excel

March 4, 2022
1,161 Views 0

In this free WPS tutorial, you will know how to convert text to number in WPS Office Excel with simple steps as follows:


· Steps to convert text to number in WPS Spreadsheet

Functions are the important tools in WPS Spreadsheet to solve problems and improve your work efficiency. To convert text to number, we can use the VALUE function.

1. Click an empty cell. Head to the Formulas tab, and click Insert Function to pop up a dialog.

2. Enter VALUE in the search box, select it and click OK.

How to convert text to number in WPS Office Excel1.gif 

3. In the new dialog, select the cell to convert and click OK. Then the function returns the numeric value of a text string.

How to convert text to number in WPS Office Excel2.gif 

4. Then convert the rest of the cells by dragging the fill handle.

How to convert text to number in WPS Office Excel3.gif 

With these steps, you are able to convert text to number quickly and freely. Did you get it?


· What is WPS Spreadsheet?

WPS Spreadsheet is a module of WPS Office(an acronym for Writer, Presentation and Spreadsheet). WPS Spreadsheet is consistent with Excel document, which helps users to work with high efficiency. Its personal basic version is free to use and it also provides abundant functions and unique features for you to explore.


Learn more advanced skills about WPS Spreadsheet :

Format cells | WPS Academy Free Office Courses


WPS Office is a free office software that is capable of creating and editing different file formats, including texts in Writer, Presentation, Spreadsheet, and PDF. No matter if you are a student or a business runner, WPS Office is a top choice. WPS Academy, along with WPS Office, offers free and useful tips to beginners who don't know where to start. In addition to the basic functions, WPS Academy can also take you to the more advanced world of office software.

Was this helpful?