81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

TO_PURE_NUMBER()

Description

Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.

How To Use in Sheets

TO_PURE_NUMBER(value)

External Links

Google Docs Help

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.