How to Working with Currencies in Excel



How to Working with Currencies in Excel

Often, we need to input special symbols like € or $ in to our Excel sheets. If you’re working with different currencies in one Excel spreadsheet, you’ll need to change the currency symbol on certain cells, without affecting other cells.

Microsoft Office Excel is a powerful spreadsheet program used by all types of people to keep track of all types of data. If you’re working with different currencies in one Excel spreadsheet you’ll need to change the currency symbol on certain cells, without affecting other cells. Excel allows you to format cells to make the dollar sign appear automatically any time you enter a number.Now, how do we do that?

How to Change the Currency Symbol for Certain Cells in Excel

1- After you’ve input your numbers, make sure that Excel identifies those cells are currencies. Select the cells you want to format. Then, select and on Number section in the Home tab, select Currency from the dropdown menu.

How to Change the Currency Symbol for Certain Cells in Excel

2- The numbers in the selected cells are all formatted as currency with Windows’ default currency symbol applied.( in my case, dollars. )

How to Change the Currency Symbol for Certain Cells in Excel

3- To change some of the currency numbers to another type of currency, such as Euros, select the cells that include the currency you wish to change. Right-click the cells and click Format cells.

excel Format cells

On the “Number” tab, “Currency” should be selected in the “Category” list. Click on the “Symbol” drop-down list, scroll down to the “Euro” options and select. (You can also change the standard two decimal places if you really want to.) Click “OK”.

excel Format cells

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

Excel currency symbols

Watch Video

Recommended For You

How To Only Print An Area İn Microsoft Excel

How To Print Only A Selected Area Of An Excel Spreadsheet

How To Copy And Paste Performance Information In Windows 10

Add a Comment

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