What Is Euro Symbol In Excel?
The Euro symbol in Excel, ‘€’, represents the official currency of the 20 states which are members of the European Union, the Euro. And while Excel allows one to insert the Euro symbol in a cell, we can set the cell in the Euro currency format.
Users can use the Euro symbol in a workbook when the ask is to display the given values in Euros.
For example, the table below lists the Eurozone member countries.
And the requirement is to enter Euro symbol in Excel cell B2 to update the table.
Then, we can use the Text Excel function CHAR in the target cell to insert the Euro symbol in Excel text.
In the above Euro symbol in Excel text example, we supply 128 as the number argument value in the CHAR() in cell B2 since the Euro symbol’s Unicode number is 0128.
And then, the CHAR() returns the Euro symbol, ‘€’, as a text value in the target cell.
Table of contents
- The Euro symbol in Excel, ‘€’, is the currency symbol of the European Union’s Eurozone member countries, which we can use in a workbook.
- Users can use the Euro symbol in a spreadsheet when they must display the currency values in Euros, with the Euro symbol prefixing or suffixing the chosen values.
- We can insert the ‘€’ symbol in Excel using the shortcut key, Alt + 0128, CHAR(128) function, or the Symbol option in the Insert tab. Otherwise, we can use the Replace-With option in the AutoCorrect Options in the Excel Options window.
- We can use the Euro currency number format from the Format Cells window to display the chosen numbers in Euros. Alternatively, we can write a VBA code to set the number format of the chosen values as Euro currency.
How To Use Euro Symbol In Excel?
We can use the Excel Euro symbol using the following methods:
#1 – Using Shortcut Key
#2 – Using ‘CHAR Function’
#3 – Using The ‘Insert’ Tab
#4 – Using The ‘Replace’ Method
Let us see each method step by step.
Excel VBA – All in One Courses Bundle (35+ Hours of Video Tutorials)
If you want to learn Excel and VBA professionally, then Excel VBA All in One Courses Bundle (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.
Method #1 – Using Shortcut Key
The steps to enter Euro symbol in Excel using the shortcut key are as follows:
- Choose the target cell, where we must show the Euro symbol.
- Press Alt + 0, 1, 2, and 8, one by one, with the Alt key pressed, to view the Euro symbol, ‘€’, in the target cell.
Method #2 – Using ‘CHAR Function’
The syntax of the Text function, CHAR(), is:
The function accepts one mandatory argument, number. And the argument value can be between 1 to 255, corresponding to the character we want to display in a cell from the character set used by our computer.
And the function return value will be a text.
The steps to add Euro symbol in Excel cell using the CHAR excel function are as follows:
- Choose a cell where we must display the Euro symbol.
- Enter =CHAR( in the cell. [ Alternatively, enter =C or =CH and double-click the CHAR function from the Excel suggestions.]
- Enter the Unicode number of the Euro symbol, 128, as the number argument value in the CHAR().
- Close the bracket and press Enter to view the Euro symbol as the CHAR() output in the target cell.
[ Alternatively, we can choose the target cell and select Formulas → Text → CHAR to choose the function from the Function Library in the Formulas tab.
The Function Arguments window will open.
Enter the Euro symbol Unicode number in the given field in the Function Arguments window.
Finally, press OK in the Function Arguments window to view the Euro symbol in the chosen cell.]
Method #3 – Using The ‘Insert’ Tab
The steps to find Euro symbol in Excel and insert it in the required cell are as follows:
- Choose a target cell where we must display the Euro symbol.
- Select the Insert tab → choose the Symbol option.
- The Symbols tab in the Symbol window opens, where we must enter the character code of the Euro symbol, 20AC, in the Character code field.
The Euro symbol, ‘€’, gets selected from the symbols listed in the Symbol window.
And click Insert.
- Click Close to exit from the Symbol window.
And the required Euro symbol gets displayed in the chosen cell.
[ Alternatively, if we do not know the character code of the Euro symbol, we can find Euro symbol in Excel using the Subset field in the Symbols tab in the Symbol window.
As explained earlier, choose the required cell and open the Symbols tab in the Symbol window.
And then, press the Subset field drop-down button to choose the Currency Symbols option from the drop-down list.
Excel will display all the currency symbols in the program.
Select the Euro symbol and click Insert to add Euro symbol in Excel cell.
Finally, click Close to complete the action.]
Method #4 – Using The ‘Replace’ Method
We can display the Excel Euro symbol by replacing a phrase with the ‘€’ symbol using the Replace method. And the steps are as follows:
- Select File → Options.
The Excel Options window opens, where we must click the Proofing option to open the tab. And then click the AutoCorrect Options button to set the required Excel autocorrect settings.
The AutoCorrect: English (United States) window opens, showing the AutoCorrect tab.
- Enter the phrase in Replace field, which we must replace with the ‘€’ symbol in Excel. And enter the ‘€’ symbol in the With field.
Next, click Add in the AutoCorrect tab.
- Click OK in the AutoCorrect: English (United States) window.
- Click OK in the Excel Options window.
Now, we can select the required cell.
Next, enter the phrase in the chosen cell, which we specified in the Replace field in the AutoCorrect tab in the AutoCorrect: English (United States) window.
And press Enter.
The entered phrase will get replaced with the ‘€’ symbol, as mentioned in the With field in the AutoCorrect tab in the AutoCorrect: English (United States) window.
Please note that we entered the specific phrase in cell A2 before adding the phrase and the Euro symbol to the Replace-With list. And that is why the word appears as is, without getting replaced with the Euro symbol.
Furthermore, the above method is case-sensitive. Also, assume we enter the specific phrase in a cell. And then, press the Spacebar to type the phrase again or any other data in the same cell. Then, the specific phrase gets replaced with the ‘€’ symbol once we press the Spacebar.
Euro Symbol In Excel – Examples
Check out the following examples to understand the Excel Euro symbol concept effectively.
The table below lists sales representatives at a firm and their average monthly and annual salary figures.
And the requirement is to display the salary figures, which have the Number data format, in Euros.
Then, the steps are as follows:
- Step 1: Select the cell range B2:C11 and right-click to choose the Excel Format Cells option in the context menu.
[ Alternatively, select the required cell range and choose Home → Number Format → More Number Formats.
Otherwise, select the required cell range and click the Number Format dialog box launcher icon in the Home tab.
We can also choose the required cell range and press Ctrl + 1.]
The above step will open the Format Cells window.
- Step 2: Choose the Currency category in the Number tab in the Format Cells window. And then, select the required Euro currency format from the Symbol field drop-down list.
And select the required negative numbers settings in the Negative numbers field.
Finally, click OK in the Format Cells window to view the values in Euros in the chosen range.
Thus, the data format of the chosen range changes from Number to Currency, though the underlying values remain the same.
We can use a VBA code to set the data format of cells as Euro currency.
For example, the table below lists the stock symbols and their prices.
Here is how to use VBA coding to display the prices, having the General data format, in Euros.
- Step 1: Choose the data range B2:B6 and press Alt + F11 to open the VBA Editor.
- Step 2: Choose the required VBA Project and select Insert → Module to open a module window.
- Step 3: Enter the VBA code in the module window to display the chosen values in the Euro currency format.
- Step 4: Click the play icon to run the code.
And now, if we go to the active sheet, we will find the data format we specified in the code applied to the chosen numbers. And the values will appear in Euros.
Furthermore, as we specify a custom format to show the numbers in Euros, the data format of the chosen range changes from General to Custom instead of Currency.
Important Things To Note
- We can enter the Euro symbol in Excelany number of times in a cell using the Shortcut Key and Insert tab methods.
- The Replace method is case-sensitive. So, we must enter the phrase we want to replace with the Euro symbol, in a cell, in the same case as in the Replace-With list in the Excel Options window.
- If we specify a custom format in the VBA code to display the Euro symbol in a chosen cell, the chosen cell’s data format will be Custom.
Frequently Asked Questions (FAQs)
We can remove Euro symbol in Excel using the following steps, explained with an example.
The table below shows the monthly sales figures, with the sales figures data format being Currency.
So, here is how to remove the Euro symbols in cells B2:B13.
• Step 1: Select the cell range B2:B13 and right-click to choose Format Cells from the contextual menu.
• Step 2: The Format Cells window opens, where the Currency category in the Number tab appears as the chosen category.
Click the Symbol field drop-down button and choose None from the drop-down list.
Finally, clicking OK in the Format Cells tab will show the Euro symbol removed from the chosen cells. And the data format of the selected range changes from Currency to Number.
The Euro symbol does not display in Excel, perhaps due to the following reasons:
• The Unicode number entered with Alt is incorrect.
• The entered character code in the Character code field in the Symbols tab in the Symbol window is incorrect.
• The chosen currency format in the Symbol field in the Format Cells window → Number tab → Currency category is incorrect.
We can insert Euro symbol in Excel on Mac using the keyboard shortcut Alt + Shift + 2.
This article must be helpful to understand the Euro Symbol In Excel, with its formula and examples. You can download the template here to use it instantly.
This has been a guide to What Is Euro Symbol In Excel. Here we learn the methods to use the Euro (€) symbol in Excel with examples and points to remember. You can learn more from the following articles –