# TO_PURE_NUMBER

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.

## Usage

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

Parameters:
1. 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 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:

• `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 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.

• `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.

You can learn more about the `TO_PURE_NUMBER` Google Sheets function on Google Support.