The VALUE function converts text values that represent numbers to numbers.

For example, you can use VALUE in combination with other functions to remove currency symbols or codes from data and convert the values to numbers.

## Syntax

VALUE(Value to convert)

## Arguments

 Argument Data type Description Value to convert Text The text value to convert to a number value.

The VALUE function returns a numeric result.

## Syntax example

VALUE(Revenue as text)

This example uses the  The VALUE function to convert the Revenue as text line item to a number value.

### Character compatibility

The VALUE function works only with text values that represent numbers. The value to be converted can contain non-numeric characters if they are:

• Special numbers such as Infinity, -Infinity, or NaN.
• Numbers that use scientific notation.
• Negative numbers that contain the - symbol.

### Use VALUE with the MID function

Some functions, such as MID, return a text-formatted result. If these results are numeric, you can use the VALUE function to convert them to number-formatted.

For example, you can use the MID function to extract all characters after the first character. This enables you to remove currency symbols from numbers stored as text. The result can then be used with the VALUE function.

In this example the Revenue as text line item is text, and contains a value for several different currencies. The Revenue as number line item uses the MID and VALUE functions to convert the text that contains a number to numbers.

 US Dollars British Pound Euro Yen Revenue as text \$2348765.38 £1674500.96 €1945632.29 ¥257478438.94 Revenue as number VALUE(MID(Revenue, 2)) 2,348,765.38 1,674,500.96 1,945,632.29 257,478,438.94

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.