How to Use Different Currency Symbols in Specific Cells in Excel
Excel is a great tool for budgeting , and if you happen to travel often or find yourself dealing with several different currencies, the spreadsheet program makes it easy to handle different currencies in one workbook. Here’s how to do that.
After you’ve input your numbers, make sure that Excel identifies those cells are currencies. Select your cells, and on Number section in the Home tab, select Currency from the dropdown menu.
All your numbers will now be labeled with the default currency — in my case, dollars. Select the cells that include the currency you wish to change. Right-click the cells and click Format cells.
A popup window will open up on the Number tab, and Currency should already be selected. Select your currency from the Symbol dropdown menu. (You can also change the standard two decimal places if you really want to.)
Now you should be able to see different currency symbols in the same Excel sheet:
What are your must-use tips and tricks that you use in Excel? What are your favorite methods for streamlining your workflow in Excel? Let us know in the comments.
Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.