Change Default Currency Specific to a File

Copper Contributor

Hi Everyone,


I have been working on all my Excel files using USD, and there is one Excel file that requires me to use another currency (let's say Japanese Yen). Is there a way to change the currency only specific to this one file to Yen while keeping other files set to USD?


Thank you!

1 Reply


You might create a new custom style named Yen that applies Yen currency format:


Apply the Yen style wherever you need it: