Dear All,

I have numbers of different currencies in "Column A", Percentages in "column B" and a formula for obtaining the product of these in "column C". It is a data entry task and I need to get the product in "column C" to have the same currency as in "column A" as I keep entering values. How can this be done.

Many thanks in advance.