TO_PURE_NUMBER

The TO_PURE_NUMBER function in Google Sheets is a versatile tool to convert a provided date/time, percentage, currency, or other formatted numeric value to a pure number without formatting. With this function, you can easily work with numerical data in its raw form. Learn more about its syntax, parameters, and usage in our comprehensive guide.

Function Syntax and Parameters

Syntax: TO_PURE_NUMBER(value)

Parameters:

• value: The date/time, percentage, currency, or other formatted numeric value to be converted.

Step-by-Step Tutorial

1. Converting date/time value to a pure number:

   • Example: If A1 has the value 6/17/2022 10:30 AM, then =TO_PURE_NUMBER(A1) will return 44625.4375.

2. Converting percentage value to a pure number:

   • Example: If A2 has the value 25%, then =TO_PURE_NUMBER(A2) will return 0.25.

3. Converting currency value to a pure number:

   • Example: If A3 has the value $1,500.00, then =TO_PURE_NUMBER(A3) will return 1500.

Use Cases and Scenarios

1. Data Analysis: Convert formatted numerical data into a pure number for further calculations.
2. Charting and Visualization: Use pure numbers to create accurate charts and visual representations of data.
3. Statistical Analysis: Perform statistical calculations on numeric data in its raw form.

Related Functions

• None

Related Articles

• None