Currency

qsami

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

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

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)
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,448
Members
410,611
Latest member
JB_101920
Top