Currency

[qsami]

How can we change the values in a workbook from one currency (£) to another ( €)?

 

[Harvey]

multiply em by the exchange rates. There is no proper Excel function for it.

 

[erik.van.geit]

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]

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]

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)