How to convert text to number in WPS Office Excel
A free Office suite fully compatible with Microsoft Office
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.
3. In the new dialog, select the cell to convert and click OK. Then the function returns the numeric value of a text string.
4. Then convert the rest of the cells by dragging the fill handle.
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?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to copy file names in Excel from a folder?
- 4. How to import external data in WPS Spreadsheet
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Top 10 simple family tree template Excel free download