Better Sheets

VALUE Google Sheets Formula

Description

Converts a string in any of the date, time or number formats that Google Sheets understands into a number.

How To Actually Use VALUE() in Sheets

VALUE(text)

In cells A1:A10, you have text representations of numbers. Use the VALUE formula to convert these text strings into actual numbers in cells B1:B10.

Your formula

Hints (2)

Locale Separator ,

Convert text to a number in Google Sheets

The VALUE function converts a text string that looks like a number, date, or time into a numeric value Google Sheets can calculate with.

See the official Google documentation link on this page, plus video examples for common formats.

1 Better Sheets Tutorial

What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.

CONCAT() DATE() MONTH() VALUE()

Transcript-matched member videos for VALUE(). Click through to watch.

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Create a brand new custom formula in Apps Script. We'll do this for our ...

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

Learn more about the VALUE() formula:

Generate a VALUE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses VALUE(). 2 free AI generations, no signup. Members get unlimited use.

More related tutorials