How To Use: VALUE Function

VALUE function converts a text value that represents a number to a number. It converts the text that appears in a recognized formats like a number, date, or time format into a numeric value.

The VALUE function is an inbuilt function in Excel under the category of String/Text Function. As a worksheet function, you can enter this as part of a formula in a cell of a worksheet.

Syntax for VALUE Function

=VALUE(text)

Arguments

Text: The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.

The text value to convert to a number is entered in arguments. If the text is not a number, the VALUE function returns #VALUE! error.

I have created the infographics for the VALUE Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.

Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.

Simply follow the instructions in the infographics below:

Normally, VALUE Function is not used as Microsoft Excel will automatically convert text to numeric values as needed. This function is provided for compatibility with other spreadsheet programs.

To learn other function like MID, QUOTIENT and KURT Functions, please click on the name of the function.

Additionally, you can download other accounting templates like Break Even Analysis Template, Salary Sheet Template and Invoice with GST Template from here.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.