How to Use Different Currency Symbols in Specific Cells in Excel
Pinterest Stumbleupon Whatsapp
Advertisement

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.

Step 1

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.

How to Use Different Currency Symbols in Specific Cells in Excel Excel Currency 1

Step 2

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.

How to Use Different Currency Symbols in Specific Cells in Excel Excel Currency 2

Step 3

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.)

How to Use Different Currency Symbols in Specific Cells in Excel Excel Currency 3

Now you should be able to see different currency symbols in the same Excel sheet:

How to Use Different Currency Symbols in Specific Cells in Excel Excel Currency 4

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.

Leave a Reply

Your email address will not be published. Required fields are marked *