Kornilios Ampatzis/ April 22, 2019/ Functions

It converts a text that represents a number to that number.

The syntax of the function is the following:

VALUE(text)

text: The text you want to convert to a number.

The text can be in any of the constant number, date, or time formats recognized by Excel. If it is not then the function returns the #VALUE! error.

The function is provided for compatibility with other spreadsheet software.

Click on the button to practice using this function, with the help of our Online Assessment Tool:

Practice

Here is an example of how to use the VALUE function:

In the cells B1:B6 set the values of the cell range A1:A6.
If their values cannot be represented by a number then set the value in the corresponding cell of the B column to 0.
You can use the conditional function IFERROR and the VALUE function.
Then

Share this Post