VALUE

Formulas / VALUE
Convert text to a number.
=VALUE(text)
  • text - required, the text to convert

Examples

  • =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.


Summary

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.

Frequently Asked Questions

What is the VALUE function?
The VALUE function is a Sourcetable function that converts text to a numeric value.
Why is the VALUE function provided?
The VALUE function is provided to support compatibility with other spreadsheet programs.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV