Needing to identify dollar figures over $10k in a string

[loginerror (Maciej Kuźmicz)]

Hi @Sheri

Could you give this topic a look?

Remove 0 from end of String

I am saving a scraped number as a string (ex: $12.50) and comparing it to an excel table that has numbers as (ex:12.5). I was using: Replace(“0”, “”) to get rid of the zeroes but it removes zeroes in a number such as .034, How do I remove the dollar sign from the front and also remove zeroes that might be on the end of the string? Thanks!

You could also see here.