WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

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

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to convert text to numbers in Excel 2016 and 2019 online

July 31, 2023
5.0K Views

If you don't know how to convert text to numbers in Excel 2016 and 2019 online. There are several ways to convert text to numbers in Excel can help you.

1.Making a rapid text to number conversion using an Excel function.

2.Make use of a special cell formatting method.

3.The text-to-column method

4.Use of the VALUE function is made.

This article will teach you how to convert text to numbers in Excel 2016 and 2019 online.

Using the Excel option to quickly convert text to numbers:

It's probably the simplest approach for Excel. In Excel, the apostrophe (') is commonly used before entering integers.We must first choose the data.

We must first click on the error handling box and select that option in order to convert the error to a number.

As a result, the text-formatted values would be instantly transformed to number format, and the SUM function would now work as intended and show an accurate result.

How to use Paste Special Cell Formatting Method in excel:

Now let's try a new approach to turning the words into numbers. In this instance, the Paste Special method is being employed. Reconsider the same data that we did in the last instance.Entering 0 or 1 in any one cell is the initial step.

We need to copy that number immediately. (We entered the number 1 in cell C2)

We must now select a number from the list.

At this point, we must press ALT + E + S to access Excel's shortcut key for the paste special method. The dialogue box below will appear as a result. Choose to multiply. (We can also try splitting.)

As a result, the SUM formula is currently functioning as anticipated and the text would be promptly translated to numbers.

Using the text to column method in excel:

This is the ultimate method for converting text to numbers. It takes a little bit longer than the first two, but having options is usually a good thing.We must first choose the data.

The Text to Columns option and the Data tab both need to be chosen.

As a result, it will activate the dialogue box below and ensure that Delimited is selected. Click the Next button.

After making sure the Tab box is checked, click the Next button.

In the subsequent window, the General option must be selected, the destination cell must be selected, and the Finish button must be pressed.

Text would be turned to numbers as a result, and SUM might now work.

Note: This above written article is an attempt to show you how to change text to numbers in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.                                    

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.