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.
