SheetFX
≡
<< Go back to all functions

VALUE

The VALUE function in Google Sheets is a powerful tool to convert a string in any of the date, time, or number formats that Google Sheets understands into a number. This function is useful when you need to perform calculations or comparisons with data that is stored as text. Learn how to use the VALUE function with our comprehensive guide.

Function Syntax and Parameters

Syntax: VALUE(text)

Parameters:

  • text: The string value to convert into a number.

Step-by-Step Tutorial

  1. Converting date string to a number:

    • Example: =VALUE("01/01/2022")
    • Result: 44610

  2. Converting time string to a number:

    • Example: =VALUE("12:30:00")
    • Result: 0.520833333333333

  3. Converting number string to a number:

    • Example: =VALUE("123.45")
    • Result: 123.45

Use Cases and Scenarios

  1. Data Conversion: Convert text-based data into a numeric format for mathematical operations.
  2. Importing Data: Convert text-based data imported into Google Sheets into numbers for analysis.
  3. Conditional Formatting: Use the VALUE function to format cells based on numeric conditions.

Related Functions

  • DATEVALUE: Converts a date string into a date value.
  • TIMEVALUE: Converts a time string into a time value.
  • N: Converts a value into a number.

Related Articles