When I copy/paste currency figures from the internet they are entered as text, meaning I can't format them and formulas won't read them. Does anyone know a formula that can help? My example is in dollars but it can have a different currency symbol at times.
e.g. $43.00
e.g. $43.00