SHARE

Do you have so much debt that it will take decades to pay off? It's time to make a budget and apply a few Excel tricks to help you pay off your debt sooner.

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

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.

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

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.

SHARE
Chris Velazco
Chris is Engadget's senior mobile editor and moonlights as a professional moment ruiner. His early years were spent taking apart Sega consoles and writing awful fan fiction. That passion for electronics and words would eventually lead him to covering startups of all stripes at TechCrunch. The first phone he ever swooned over was the Nokia 7610, because man, those curves.

LEAVE A REPLY

Please enter your comment!
Please enter your name here