TO_PURE_NUMBERformula 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
- Examples of using
TO_PURE_NUMBERformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
TO_PURE_NUMBERformula 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.
TO_PURE_NUMBERnot working? Here are some common mistakes people make when using the
TO_PURE_NUMBERGoogle 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 non-numeric values
If you try to use
TO_PURE_NUMBER on a non-numeric 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.
The following functions are similar to
TO_PURE_NUMBER or are often used with it in a formula:
VALUEformula 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.
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.
CLEANformula is used to remove all non-printable 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.
CONVERTformula 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.
TEXTformula 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.
You can learn more about the
TO_PURE_NUMBER Google Sheets function on Google Support.