Formulas > =VALUE()
How To Use VALUE() Function in Google Sheets
Description
How To Actually Use VALUE() in Sheets
VALUE(text)
Try VALUE yourself
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.
Hints (2)
-
Remember to apply the formula to each cell in the range.
-
You can drag the fill handle to copy the formula down.
1 Better Sheets Tutorial
What is this Ampersand Doing in Google Sheets?
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.
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()
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.
Generate a VALUE() formula