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