I am saving a scraped number as a string (ex 12.50$) and comparing it to an excel table that has numbers as . I was using 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?