HomeApplicationOffice information

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!

5 ★ | 1 Vote

You should read it

May be interested

  • How to use ConcateNate function on ExcelHow to use ConcateNate function on Excel
    concatenate function on excel is a function that connects strings of characters in different data columns in a table, forming a complete string of characters.
  • The function takes a string in ExcelThe function takes a string in Excel
    the function takes a string in excel. the function to get the string in excel includes 3 types of left, mid and right with different string functions. to better understand the three types of functions that take these strings, please follow the following article of tipsmake.com.
  • HOUR function - The function converts a serial number into an hour in ExcelHOUR function - The function converts a serial number into an hour in Excel
    hour function: the function returns the hour value in the time value hour minute second or the date value containing the hour.
  • PROPER function in ExcelPROPER function in Excel
    the proper () function capitalizes the first letter in a text string if it's a non-letter character (for example, a space) and converts all other letters to lowercase.
  • The MID function in Excel, how to use the MID function, and examplesThe MID function in Excel, how to use the MID function, and examples
    the mid function in excel, how to use the mid function, and examples. the mid function in excel is a function of the text function group, you use the mid function if you want to cut the string in the middle of the text string when processing the string. if you do not know or do not understand the mid function, then you
  • TIMEVALUE function - The function returns the decimal number of time expressed as a text string in ExcelTIMEVALUE function - The function returns the decimal number of time expressed as a text string in Excel
    timevalue function: the function returns the decimal number of time indicated by a text string. the decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 am) to 23:59:59 (11:59:59 pm). syntax: timevalue (time_text)
  • The function atoi () in CThe function atoi () in C
    the int atoi function (const char * str) in standard c library converts a string pointed to by parameter str to an integer (int type).
  • Object Number in JavaScriptObject Number in JavaScript
    the number object represents the date in the form of a numeric value, or an integer or floating-point number. generally, you don't need to worry about number objects because the browser automatically converts number literals to illustrate the number classes.
  • How to use the LEN function in ExcelHow to use the LEN function in Excel
    the len function in excel is used to measure the length of a certain string of characters, including spaces and correctly return the total character for the user.
  • MID and MIDB functions to cut strings in ExcelMID and MIDB functions to cut strings in Excel
    the mid () function returns a string from a text string, with the position to start extracting from the text string and the number of characters returned by the string that is specified. functions used in languages ​​use a single-byte character set (sbcs) and always count each character as 1.

Office information