Learn How to Change Currency Symbols for Certain Cells in MS Excel

Sometimes you need to display multiple currencies in same Excel spreadsheet. To change some of the numbers to another type of currencies such as Euro, Yen, Pound, or some other currency, follow below steps :
Step #1. Select the range of cells you want to convert to another currency (Japanese Yen in this example)

Step #2. Right click and select Format Cells… >Click on Currency and select Yen from the symbol drop-down menu > Click OK

Final result should look like this

Hope you will find this information useful.