Convert text to number with VALUE formula in Excel

=VALUE("$1,000")

=VALUE(A2)

=VALUE(RIGHT(A2,3))

References
https://www.ablebits.com/office-addins-blog/2018/07/18/excel-convert-text-to-number/
https://exceljet.net/excel-functions/excel-value-function