Monday 9 September 2019

Value Function in Excel

The value function is a function that converts a text that represents a number to number. The value function will change the same text that has a numeric value in the cell.


Syntax of the Value Function


=VALUE(Text)

Here text arguments must be Number, Date, and Time format.


When you try to convert a non-numeric text it gives a #VALUE error.


No comments:

Post a Comment