Currency

[Jarvonimbus]

I have a spreadsheet with many cells formatted as either currency or custom with pounds sterling as the currency.

I have to re-design this for use by a site in Germany. Is there any way to change the currency easily to Euros via a setting/options change or am I going to have to re-format manually?

Many thanks for any help

 

[AnotherHiggins]

Well the problem is going to be that the exchange rate is dynamic, isn't it? It seems to me that simply changing the symbol from Pound to Euro isn't going to be good enough.

£1 != €1


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Hi,

Unless you code a solution in VBA, it will be manual. If you choose to do this, please repost in ...

VBA Visual Basic for Applications (Microsoft) forum707

I'd sugggest that you document the ranges and put them in a table for future reference.

Skip,

_[red][/red]

 

[Jarvonimbus]

Thanks Skip.

Anotherhiggins - the exchange rate isn't relevant in this case - it's a spreadsheet for completion by the user not a report. Cheers anyhows