I currently manage vendors in Japan but need to also have currency in dollar for our finance/accounting in the US. 

I think the only current option is to change the whole account setting to change the currency, but that will prevent me from having two currencies, and will also change the entire setting to Japanese. 


Is there a way to fix this? Have US as the country setting and have other currencies in the sheet? 




You can set currencies per cell so it shouldn't be a problem.

Hope that helps!

Have a fantastic day!


Andrée Starå

Workflow Consultant @ Get Done Consulting

Hi there,


You can use the currency formatter to indicate each cell's currency, as Andrée was mentioning.  The default currency will likely not show an indicator.  By this, I mean that, for example, my account is in English (U.S.), so by default, my currency settings are USD.  If I format a cell/column/row in USD, it will display $25.00 and not USD$25.00.


However, it will put the indicator for any other currency I format in my sheet.   For example, it will put CAD in front of Canadian-formatted items in my sheet.  Here's some information on formatting a currency in your sheet.


Here's some information on setting your default currency settings.