Currency Formatting for multiple currencies

**rohithkotagiri** · 01-10-2013, 12:11 AM

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.

**Special-K** · 01-10-2013, 09:55 AM

Example data?

**rohithkotagiri** · 01-11-2013, 02:09 AM

Originally Posted by Special-K

Example data?

Column A Column B Column C
$ 100 10% 10
GBP 200 20% 40
EUR 300 30% 90

Capture.JPG

Like in above example (photo attached), Column C gives the product of Column A and Column B but not the currency Format in Column A.

**Palmetto** · 01-12-2013, 09:00 AM

You question is similar to this one: VBA Currency Code

**saw_ajay** · 07-04-2018, 10:43 AM

hi...

I need help with formatting multiple currency in a single cell.... Is it possible to format a single cell for multiple currencies so that at the time of input I can select the currency type ?

Regards
Ajay Saw

**protonLeah** · 07-04-2018, 03:17 PM

saw_ajay,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.