Google Sheets TO_PURE_NUMBER Function: Syntax, Examples & Tips

What Is TO_PURE_NUMBER?

TO_PURE_NUMBER strips the formatting from a numeric value and returns the bare number underneath. A cell showing $1,234.50 becomes 1234.5; a cell showing 45% becomes 0.45; a date such as 1 January 2026 becomes its serial number, 46023.

It is the opposite of the formatting functions TO_DOLLARS, TO_PERCENT and TO_DATE, which take a plain number and add a display format.

Understanding "Pure" Numbers

Spreadsheets separate a cell's value from its format. Dates are counts of days since 30 December 1899, times are fractions of a day, percentages are fractions of 1, and currency is just a number with a symbol. TO_PURE_NUMBER exposes the stored value so you can see exactly what Sheets is working with.

Basic Examples

Remove currency formatting

=TO_PURE_NUMBER(B2)

If B2 shows $99.00, the result is 99.

See a date's serial number

=TO_PURE_NUMBER(DATE(2026, 10, 26))

Turn a time into hours

=TO_PURE_NUMBER(C2) * 24

A duration of 7:30 becomes 0.3125 days, and multiplying by 24 gives 7.5 hours.

Clean output from formatting functions

=TO_PURE_NUMBER(TO_PERCENT(0.3))

Returns 0.3 with no percent formatting.

Why Use It?

• Debugging: When a comparison or lookup behaves unexpectedly, TO_PURE_NUMBER shows the actual value behind the display — for example, revealing that a "date" is really a date-time with a fractional part.
• Exports and integrations: Some systems want raw numbers without currency symbols or percent signs.
• Arithmetic on dates and times: Getting the serial number makes date maths explicit.
• Overriding inherited formats: Formulas that reference a date cell often inherit date formatting; TO_PURE_NUMBER forces a plain number display.

TO_PURE_NUMBER vs. VALUE

These two are easy to mix up:

• VALUE parses text that looks like a number (such as "1,200" or "$5") and returns a number.
• TO_PURE_NUMBER takes a value that is already numeric but formatted, and removes the formatting.

If your data arrived as text — left-aligned, or ISTEXT returns TRUE — VALUE (or DATEVALUE for dates) is usually the right tool.

Common Use Cases

• Preparing data for CSV export or API upload.
• Converting time durations into decimal hours for payroll.
• Inspecting date serials when date comparisons don't line up.
• Removing currency or percent formatting introduced by other formulas.

Common Errors

• Text isn't converted the way you expect: Values imported as text strings aren't really numbers yet. Use VALUE or DATEVALUE first.
• Large unexpected numbers: A result around 46,000 means the input was a date — that's its serial number, not an error.
• Decimals on a date: A fractional part means the value includes a time. Use INT to drop it.

Tips and Best Practices

• Use TO_PURE_NUMBER as a quick diagnostic in a spare column when data looks right but behaves wrong.
• Multiply time results by 24 for hours, or by 1440 for minutes.
• Apply a number format afterwards if you want specific decimal places.

Related Functions

VALUE, DATEVALUE, TO_TEXT, TO_DATE, TO_DOLLARS, TO_PERCENT, and N.