I am currently making a sheet to make it easier to make quotations, however we work on ''international level''. Therefor i was wondering if it is possible to have some kind of formula (maybe in combination with conditional formatting) that will change the currency from EUR to USD? I think the swapping of the symbol should be possible (correct me if I am wrong), but i don´t know how. Also the problem with currency´s is (ofcourse) that the exchange rate isn´t a stable factor, so is it possible that my worksheet will somehow retrieve this data from the internet?

-note: The quotation sheet will draw the numbers from a main information sheet using ''=''formulas and also add's calculates the total price using the SUM function.

Any help/suggestions will be greatly appreciated, thanks in advance!