Possible to convert a string into a decimal


#1

I’m trying to make a column show different currencies.
I’ve got a column for price and a column for € price and formula field that is controlled by a 'currency switch' which determines if the price in the formula field is shown in or €.
My problem is I need to multiply the formula field with another field but it’s now a string as it has either a $ or a € attached to it.
Is it possible to take and convert the numbers in the string back into a decimal?


#2

Yes it is: