Currency

qsami

New Member
Joined
Apr 5, 2006
Messages
29
How can we change the values in a workbook from one currency (£) to another ( €)?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
multiply em by the exchange rates. There is no proper Excel function for it.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
How can we change the values in a workbook from one currency (£) to another ( €)?
Hi,

can you explain a bit more what you exactly want to do
I can see different situations which could occur
1. change values once and for all without the need to store exchangerates
2. table with both currencies next to each other
3. ability to switch currencies permanently (values stay in same cells)

kind regards,
Erik
 

qsami

New Member
Joined
Apr 5, 2006
Messages
29
Thanks Eric,

Is it practically possible to change the no.s in £ to € in all sheets of the workbook using one command?
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Thanks Eric,

Is it practically possible to change the no.s in £ to € in all sheets of the workbook using one command?
yes, it is
I've done this for a large workbook using formulas
of course this makes the whole thing heavier
you could also use a macro to change the actual values each time

it would be good to tell us more about your workbooklayout ...
to my sense a few rows and columns will be enough to be relevant
think about mosting a clear example

you can use colo's htmlMaker (see bottom page) or "Table-It" (see my signature)
 

Forum statistics

Threads
1,141,011
Messages
5,703,728
Members
421,312
Latest member
Mooncake1

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