You often need to convert text to numbers while working with Excel. Excel has a built-in function VALUE for this purpose. The VALUE function is a TEXT function that takes a String representing a number and converts it to a numeric value. In this tutorial, you will learn about the uses of the VALUE function.
How to Convert Text to Numbers Using the Value Function in Excel
The Excel VALUE function takes an input of a known format like text string, date or time and converts it to a number value.
This is a required value. It is the text or reference to the cell that you are going to convert to a numeric value.
The following example shows the use of the VALUE function in Excel. Column A has the values you are going to convert. Column B Shows their actual form, column C shows the formula used and column D has the results.
- The first example converts the text string =”$350.00” to numbers. You don’t see any changes, but the formula =VALUE(A3) takes the string =”350.00” and converts it to numbers in the background. You need to use the = sign before the string for it to work. Otherwise, you will get a #VALUE error.
- The next example converts the date 10/2/2018 to numbers. Here Excel converts the date to a serial number that Excel recognizes as a date and you get the output 43375. Your computer’s date settings might cause the output of this serial number to vary.
- The last example takes the time 5:00:00 PM as an argument and converts it to a number. It works in the same way as the previous example. Excel converts the time to a serial number. Here, you get the output 0.7083333 which is “17:00” minus “12:00”.