Convert text to a number.

`VALUE(text)`

- text - required, the text to convert

`=VALUE("July 15, 2021")`

The VALUE function can be used to convert a date in text format to a serial number in Sourcetable. For example, this example will return the serial number 44392.

`=VALUE("$125.50")`

The VALUE function can also be used to convert a currency value in text format to a number. For example, this formula will return the number 125.50.

`=VALUE("32.5%")`

The VALUE function can also be used to convert a percentage value in text format to a decimal number. For example, this formula will return the decimal number 0.325.

The VALUE function converts text to a number in Sourcetable for compatibility with other spreadsheet programs. It takes a text argument as required and returns the converted number.

- The VALUE function allows Sourcetable to be compatible with other spreadsheet programs and convert text to numbers automatically.

The VALUE function is a Sourcetable function that converts text to a numeric value.

The VALUE function is provided to support compatibility with other spreadsheet programs.

Drop CSV