View Single Post
 
Old 06-15-2017, 12:41 AM
OfficeOffice OfficeOffice is offline Windows 10 Office 2016 for Mac
Novice
 
Join Date: Jun 2017
Posts: 1
OfficeOffice is on a distinguished road
Default Changing euro signs to other currencies in big excel format including graphs

Hey guys,

I am trying to figure out a way in which I can convert the signs of currencies in my whole format easily. I do not want to add exchange rates, but only change the sign!

The format includes lots of graphs.
The problem when I select everything and change the currency, it also changes percentages and years to a currency which basiccaly Changes everything.

Does anyone have a simple solution for this?
Or a suggestion for a macro I can build?

Cheers!

Last edited by Pecoflyer; 06-15-2017 at 06:51 AM. Reason: Removed vulgar language
Reply With Quote