Excel VALUE Function
The Excel VALUE function converts a text string that comprises numbers into a numeric value
Example: Excel VALUE Function
|
=VALUE("B5")
|
Result in cell C5 (1234) - converts a text string into a number, removing the leading zero.
|
|
=VALUE("B6")
|
Result in cell C6 (42809) - converts a date (11/03/2017) into a numeric value.
|
|
=VALUE("B7")
|
Result in cell C7 (205) - converts a currency format into a number.
|
METHOD 2. Excel VALUE function using the Excel built-in function library
EXCEL
Formulas tab > Function Library group > Text > VALUE > populate the input box
| =VALUE(B5) Note: in this example we are converting a text string in cell (B5) into a number, removing the leading zero. |
 |
DESCRIPTION
The Excel VALUE function converts a text string that comprises numbers into a numeric value.
The Excel VALUE function converts a text string that comprises numbers into a numeric value.
SYNTAX
=VALUE(text)
=VALUE(text)
ARGUMENTS
text: (Required) The text string that comprises numbers to convert into a numeric value.
text: (Required) The text string that comprises numbers to convert into a numeric value.
ADDITIONAL NOTES
Note 1: If the text string contains text, meaning not equivalent to numbers, the function will return a #VALUE! error.