Value function in Excel gives the value of a text which represents a number for example if we have a text as $10 this is actually a number format in a text, using value function on this data will give us 10 as result so we can see how this function gives us the numerical value represented by a text in excel.

**Syntax**: =VALUE(text)

The VALUE function syntax has the following arguments:

**Text**(Required) The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.

**Example**: Let’s look at some Excel VALUE function examples and explore how to use the VALUE function as a worksheet function in Microsoft Excel:

**Syntax**: =VALUE(A15)

**Result**:

Based on the Excel spreadsheet above, the following VALUE examples would return:

**Syntax**: =VALUE(A16)

**Result**: 0.0000001

**Syntax**: =VALUE(A17)

**Result**: 0.2

**Syntax**: =VALUE(A18)

**Result**: 10

**Syntax**: =VALUE(A19)

**Result**: 0.375

**Syntax**: =VALUE(A20)

**Result**: 43934

**Syntax**: =VALUE(A21)

**Result**: #VALUE!

**Syntax**: =VALUE(A22)

**Result**: #VALUE!

**Syntax**: =VALUE(A23)

**Result**: 600000