I am not quite sure what you want. Do you want to set up a spreadsheet which
will format currency  as Rands if it is used in South Africa, Yen if it is used
in Japan and Bahts if it is used in Thailand

or

Do you want on one spreadsheet to have some Rands, Some Yen, Some Bahts etc
and each to be formatted according to the country it relates to?