Input CURRENCY SYMBOL to format all #'s the same currency

CWISE

New Member
Joined
Aug 29, 2005
Messages
5
Hi,

I have a spreadsheet where the user needs to input the currency symbol (i.e. USD, EUR, MXN, etc). Based upon what currency they put in the input into the cell, I am needing to format all numbers within certain cells to be the same currency. The currency will change multiple times so the currency symbol and number have to be dynamic.

Any ideas? And how I would even begin to look this excel function up in "help". I went to datapigtechnologies.com and although it skirted around formating functions- I never seem to what I needed in this instance.

Appreciate the help.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
When you say you want the numbers to change are you are saying you would want it to update to whatever the current exchange rte is? (Ex $1.00 = £0.57 = ¥118.49)
 

CWISE

New Member
Joined
Aug 29, 2005
Messages
5
No - it is more simple than that.

Basically in cell D10 the user is to input MXN or USD or EUR whichever currency applies.

For some 10 other cells that are numbers, I am needing to format the numbers to be in the same currency.

Right now the user has to input the answer in D10 and manually format each cell (format cells/numbers/currency/MXN, etc) to have the currency symbol display with the number.

I am wanting the spreadsheet to automatically format the other cells based upon what is input into D10.
 

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
OK you could do that by macro or by formula the pro to macro is that it would leave the numbers in number format the con is of course you have to mess with code. You can do it with az formula too but it would be a little cumbersome. I would need to know how your sheet was laid out and what it was supposed to be showing. Any prefrence here?
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Re: Input CURRENCY SYMBOL to format all #'s the same currenc

CWISE said:
Hi,

I have a spreadsheet where the user needs to input the currency symbol (i.e. USD, EUR, MXN, etc). Based upon what currency they put in the input into the cell, I am needing to format all numbers within certain cells to be the same currency. The currency will change multiple times so the currency symbol and number have to be dynamic.

Any ideas? And how I would even begin to look this excel function up in "help". I went to datapigtechnologies.com and although it skirted around formating functions- I never seem to what I needed in this instance.

Appreciate the help.
Hi CWISE:

To automate it try the following Worksheet_Change event code ...
Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    'let us say the range of cells to be formated is A8:b12
    If Target.Cells.Address = "$D$10" Then
        Range("a8:b12").NumberFormat = """" & [d10] & """ 0.00"""""
    End If
End Sub
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,951
Messages
5,834,540
Members
430,295
Latest member
amdis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top