VALUE Function

The VALUE () is a text function which takes text as an argument and converts a text string that represents a number to a number.

Formula:


=VALUE (text)
In the above syntax, the argument text , denotes the text which is enclosed inside the quotation marks or a reference to a cell containing the data you want to change.

Video Tutorial:


Let us see how the value function converts a text string, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question