What I have understood, that currency  should be fromatted on the basis of the
country. meaning If the same sheet being open in India the currency would be
formatted to RS, If it is US it would be $ like this.
If this is what I understood, we need to write a VBA code using this Lib
GetLocaleInfo Lib "kernel32", which will return you the country
GetCountryName = GetUserLocaleInfo(LCID, LOCALE_SISO3166CTRYNAME)
Now using the SELECT...CASE you can change the global setting of the currency
irrespective to country.