< Go Back

Excel VALUE Function

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. 

Syntax

=VALUE(TEXT)

Arguments

TEXT

This is a required value. It is the text or reference to the cell that you are going to convert to a numeric value.

Examples

Figure 1. VALUE Function Examples

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”.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar