As the title says: How can I convert data like $14,500.00 and $1,206.80 from text to a number in Google Sheets?

I tried the special format and then $#,##0.00but it didnt work. Any suggestions?


1 Answer 1


Use this pattern:

=iferror( value( regexreplace( trim(A2), "[^\d.]", "" ) & " " ) )

The values you quote should be perfectly valid as is, provided that the spreadsheet locale is set to United States or another locale that uses period as decimal mark and $ as currency symbol. To avoid the need to convert these values in the first place, set File > Settings > Locale before you import the values.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.