AI · 1 min read

TO_PURE_NUMBER

TO_PURE_NUMBER function in Google Sheets: Strips formatting to a plain number.

Parser function · Google Sheets

TO_PURE_NUMBER function

Strips formatting to a plain number.

Availability

PlatformStatus
ExcelNot listed
Google SheetsListed
This function has no same-named match in Excel.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.