You can use the following formulas to convert text to numbers in Google Sheets:
Method 1: Convert Text to Number
=VALUE(A1)
Method 2: Convert Currency to Number
=TO_PURE_NUMBER(A1)
Method 3: Extract Numbers from Text
=SPLIT(A1,CONCATENATE(SPLIT(A1,".0123456789")))
The following examples show how to use each formula in practice.
Example 1: Convert Text to Number
We can type the following formula into cell B2 to convert the text in cell A2 to a number:
=VALUE(A2)
We can copy and paste this formula down to the remaining cells in column B:
All of the cells in column B are now a number.
To verify this, we can type =ISNUMBER(B2) in cell C2:
We can see that the value in cell B2 is a number since the ISNUMBER() function returned TRUE.
Example 2: Convert Currency to Number
We can type the following formula into cell B2 to convert the currency value in cell A2 to a number:
=TO_PURE_NUMBER(A2)
We can copy and paste this formula down to the remaining cells in column B:
All of the cells in column B are now a number.
To verify this, we can type =ISNUMBER(B2) in cell C2:
We can see that the value in cell B2 is a number since the ISNUMBER() function returned TRUE.
Example 3: Extract Numbers from Text
We can type the following formula into cell B2 to extract numbers from the text in cell A2:
=SPLIT(A2,CONCATENATE(SPLIT(A2,".0123456789")))
We can copy and paste this formula down to the remaining cells in column B:
All of the cells in column B are now a number.
To verify this, we can type =ISNUMBER(B2) in cell C2:
We can see that the value in cell B2 is a number since the ISNUMBER() function returned TRUE.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
How to Extract Substring in Google Sheets
How to Convert Dates to Strings in Google Sheets
How to Convert Between Month Name & Number in Google Sheets
