Excel Value Function

This post will guide you how to use Excel VALUE function with syntax and examples in Microsoft excel.

Description

The Excel VALUE function converts a text value that represents a number to a numeric value.

The VALUE function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The VALUE function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000.

Syntax

The syntax of the VALUE function is as below:

= VALUE  (text)

Where the VALUE function arguments are:
Value -This is a required argument. The text value that can be converted into a number.

Note: if text value is not a numeric value, the value function will return a excel #VALUE! Error.

Example

The below examples will show you how to use Excel VALUE Text function to convert a text value to a numeric value.

#1 To convert a text in B3 cell to a number, just using formula:= VALUE(B3).

excel value function example

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar