TO_PURE_NUMBER
TheTO_PURE_NUMBER
formula is used to convert a value into a pure number format. This is useful when dealing with data that may contain unwanted characters or formatting, such as currency symbols or commas. The formula removes these characters and returns a plain number.
 How to use
TO_PURE_NUMBER
formula?  Examples of using
TO_PURE_NUMBER
formula TO_PURE_NUMBER
formula not working? Similar formulas to
TO_PURE_NUMBER
Usage
Use the TO_PURE_NUMBER
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The value to be converted into a pure number format.
Examples
Here are a few example use cases that explain how to use theTO_PURE_NUMBER
formula in Google Sheets.
Removing Currency Symbols
When dealing with financial data, currency symbols can be a hindrance. The TO_PURE_NUMBER
formula can be used to remove these symbols and convert the value into a pure number.
Cleaning Up Commas
Large numbers are often separated by commas for readability, but this can cause problems when using the data in calculations. The TO_PURE_NUMBER
formula can remove these commas and return a plain number.
Common Mistakes
TO_PURE_NUMBER
not working? Here are some common mistakes people make when using the TO_PURE_NUMBER
Google Sheets Formula:
Forgetting to specify a value
If you forget to include a value to be converted, you will receive an error message. Make sure to include the value you want to convert in the formula.
Using with nonnumeric values
If you try to use TO_PURE_NUMBER
on a nonnumeric value, such as text or a boolean, you will receive an error message. Make sure to only use this formula on values that contain numeric data.
Related Formulas
The following functions are similar to TO_PURE_NUMBER
or are often used with it in a formula:

VALUE
The
VALUE
formula in Google Sheets converts a text representation of a number to an actual number. This formula is most commonly used when you have imported data from another source that is formatted as text, but you need to use it in a numerical calculation. 
TRIM
The TRIM formula removes any leading and trailing whitespace from text in a cell. This can be useful when importing data or when dealing with data that includes extra spaces. The TRIM function is commonly used in data cleaning and formatting.

CLEAN
The
CLEAN
formula is used to remove all nonprintable characters from a given text string. This is useful when dealing with imported or copied data that contains hidden characters that can cause issues with further processing. 
CONVERT
The
CONVERT
formula is used to convert a value from one unit of measurement to another. This formula is most commonly used to convert metric units to imperial units or vice versa. 
TEXT
The
TEXT
formula is used to format a number into text using a specified format. The format can include special characters such as currency symbols, decimal points, and thousands separators. This formula is useful when you need to display numbers as text in a specific format.
Learn More
You can learn more about the TO_PURE_NUMBER
Google Sheets function on Google Support.