## Excel Version in which VALUE functions can work:

Excel VALUE function works in all Excel Versions.

## About Excel VALUE function:

The Microsoft Excel VALUE formula converts a text value that represents a number to a number. It is a built in String or Text function in excel. It also can be used as a worksheet function.

## Syntax for VALUE:

=VALUE(text)

Parameters:

text : The cell to convert to a number.If *text* is not a number, the VALUE formula will return #VALUE!.

## Using VALUE:

Let’s look at some Excel VALUE function examples and explore how to use the VALUE as a worksheet function in Microsoft Excel. Take B3, B4 and B5 are the cell references respectively.

Words |
Formula |
Result |

14586 | =VALUE(B2) | 14586 |

25478 | =VALUE(B3) | 25478 |

458mango | =VALUE(B4) | #VALUE! |