The VALUE function converts a numeric string to a number format in Excel

The VALUE () function helps you convert a string to a numeric form, which is rarely used alone but often combined with functions like LEFT (), RIGHT (), MID (), etc. For details. Regarding the syntax and usage of the VALUE () function, you follow the article below.

The VALUE function converts a numeric string to a number format in Excel Picture 1

The article shows you the syntax, how to use the VALUE () function and how to combine the VALUE () function with other functions in Excel.

Description

The VALUE () function is used to convert a series of numbers to a number.

The VALUE () function is often used in conjunction with string-cutting functions: LEFT () - cuts the left string, RIGHT () - cuts the right string, MID () - cuts the string at Between. Because when cutting the string, the format of the string to be cut is not a numeric format, you need to use the VALUE () function to convert it to numeric.

Syntax

= VALUE (text)

Where: text is a series of numbers enclosed in quotes or a formula, referring to the cell containing the series of numbers that you want to convert.

Note

- text can be a date, time or constant format, if the text is not in these formats then the VALUE () function will return an error.

- Usually you do not need to use the VALUE () function because Excel will convert text to numbers as needed, but there are some cases you need to use this function.

For example

- The VALUE () function.

The VALUE function converts a numeric string to a number format in Excel Picture 2

- Combine the VALUE () function with the string cutting function RIGHT ().

The VALUE function converts a numeric string to a number format in Excel Picture 3

- Combine the VALUE () function with the IF () function.

The VALUE function converts a numeric string to a number format in Excel Picture 4

With the specific examples in the above article, you can better understand the VALUE () function in Excel. So, now you can apply the VALUE () function when you need to convert strings into numbers. Good luck!