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.
2- The numbers in the selected cells are all formatted as currency with Windows’ default currency symbol applied.( in my case, dollars. )
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.
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”.
Now you should be able to see different currency symbols in the same Excel sheet:
Recommended For You