If you work with Excel, then you know that there are certain cells that have a specific currency symbol. For example, the cell for the Currency Symbol in the Money tab in Excel is named “Currency.” If you want to change the currency symbol for that cell, you can do so by using the Format Cells dialog box. To open the Format Cells dialog box, click on the button next to “Currency Symbol.” In the Format Cells dialog box, you will see a list of all of the cells in your spreadsheet. The cells in this list are sorted by their name (in alphabetical order). The first column in this list is called “Name.” The second column is called “Symbol.” The third column is called “Value.” The fourth column is called “Description.” This column tells you what type of value will be displayed for each cell in this list. You can see these values in three different ways: as text, as a number, and as a color. The text values are always displayed as text. You can also see these values as numbers if you want them to be display as numbers. You can also see these values as colors if you want them to be display as colors. To change one of these values, just click on it and then click on the Change button next to it.
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. When you format your numbers as “Currency”, you can easily use multiple currency symbols in the same Excel spreadsheet.
RELATED: How to Change Windows’ Default Currency from Dollars to Euros
NOTE: If you’re going to use the same currency symbol throughout your Excel spreadsheets, you can change the default currency symbol throughout Windows instead. This is for situations when you want two different currency symbols in the same document.
Before you do anything else, make sure the numbers in question are formatted as currency. To do this, select the cells you want to format.
Then, select “Currency” from the “Number Format” drop-down list in the “Number” section of the “Home” tab.
The numbers in the selected cells are all formatted as currency with Windows’ default currency symbol applied.
To change some of the currency numbers to another type of currency, such as Euros, select the cells you want to change.
In the “Number” section of the “Home” tab, click he “Number Format” button in the lower-right corner of the section.
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 one, depending on whether you want the Euro symbol before or after the number. Click “OK”.
The selected numbers now have a different currency symbol applied to them.
You may have noticed a drop-down list in the “Number” section of the “Home” tab that has a currency symbol on it. This may seem like an easier way to change the currency symbol for the selected cells. However, this is the “Accounting Number Format”, not the standard currency format.
If you select “Euro” from the “Accounting Number Format” drop-down list…
…you’ll get Euro symbols on your numbers, but they will display in the accounting format, which aligns the decimal points in a column. Notice that the currency symbols are not right next to the numbers. Instead, they are left-aligned.
You can also change the number of decimal places and the format of negative numbers on the “Number” tab on the “Format Cells” dialog box.
