Google Sheets VALUE Function

This post will guide you how to use Google Sheets VALUE function with syntax and examples.

Description


The Google Sheets VALUE function converts a text string that represents a number to a numeric value.

The VALUE function can be used to converts a text string in the date, time or number formats into a numeric value in google sheet. The purpose of this function is to convert text to a number and its returned values is a numeric value.

The VALUE function is a build-in function in Google Sheets and it is categorized as a Text Function.

Syntax


The syntax of the VALUE function is as below:

= VALUE (text)

Where the VALUE function argument is:

  • Text -This is a required argument. The text string that you want to convert it to a number.

Note:

  • Text can be in any of the constant number, date, or time formats. And if text is not a number, the VALUE function will return #VALUE! Error.
  • If the VALUE function is not able to convert a text value to a numeric result, it returns a #VALUE! Error message.
  • VALUE function is provided for compatibility with other spreadsheet applications.

Google Sheets VALUE Function Examples


The below examples will show you how to use google sheets VALUE function to convert string to a number.

#1 To convert a text in B3 cell to a number, just using formula:

= VALUE(B3)

google sheets value function1

#2 to convert a text string that is not a recognized format (number, date, time format) into a numeric value, using the below formula:

=VALUE(B5)

google sheets value function1

You will see that the #VALUE! Error will be returned by the VALUE function. Because the text is not a number.

 

 

 

 

 

 

 

 

Sidebar