Check Sheet Logo
Check Sheet


The TO_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.


Use the TO_PURE_NUMBER formula with the syntax shown below, it has 1 required parameter:

  1. value (required):
    The value to be converted into a pure number format.


Here are a few example use cases that explain how to use the TO_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 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:


    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.


    The CLEAN formula 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.


    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.