Euro Symbol In Excel

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.

Euro Symbol in Excel Example - 1

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.

Euro Symbol in Excel Example - 2

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.

Key Takeaways
  • 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.

Method #1 – Using Shortcut Key

The steps to enter Euro symbol in Excel using the shortcut key are as follows:

  1. Choose the target cell, where we must show the Euro symbol.

  2. Press Alt + 0, 1, 2, and 8, one by one, with the Alt key pressed, to view the Euro symbol, ‘€’, in the target cell.


    Euro Symbol in Excel - Method 1 - Step 2

Method #2 – Using ‘CHAR Function’

The syntax of the Text function, CHAR(), is:

Euro Symbol in Excel - CHAR Syntax

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:

  1. Choose a cell where we must display the Euro symbol.
  2. Enter =CHAR( in the cell. [ Alternatively, enter =C or =CH and double-click the CHAR function from the Excel suggestions.]
  3. Enter the Unicode number of the Euro symbol, 128, as the number argument value in the CHAR().
  4. Close the bracket and press Enter to view the Euro symbol as the CHAR() output in the target cell.
Euro Symbol in Excel - Method 2 - 1

[ Alternatively, we can choose the target cell and select Formulas Text CHAR to choose the function from the Function Library in the Formulas tab.

Method 2 - 2

The Function Arguments window will open.

Method 2 - 3

Enter the Euro symbol Unicode number in the given field in the Function Arguments window.

Method 2 - 4

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:

  1. Choose a target cell where we must display the Euro symbol.
  2. Select the Insert tab → choose the Symbol option.
Method 3 - Step 2
  1. 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.

Method 3 - Step 3
  1. Click Close to exit from the Symbol window.
Euro Symbol in Excel - Method 3 - Step 4

And the required Euro symbol gets displayed in the chosen cell.

Method 3 - Step 4b

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

Method 3 - Step 4c

Excel will display all the currency symbols in the program.

Method 3 - Step 4d

Select the Euro symbol and click Insert to add Euro symbol in Excel cell.

Method 3 - Step 4e
Euro Symbol in Excel - Method 3 - Step 4f

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:

  1. Select File Options.
Euro Symbol in Excel - Method 4 - Step 1a
 Method 4 - Step 1b

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.

 Method 4 - Step 1c

The AutoCorrect: English (United States) window opens, showing the AutoCorrect tab.

 Method 4 - Step 1d
  1. 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.

Method 4 - Step 2
  1. Click OK in the AutoCorrect: English (United States) window.
Method 4 - Step 3
  • Click OK in the Excel Options window.
Method 4 - Step 4a

Now, we can select the required cell.

Method 4 - Step 4b

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.

Method 4 - Step 4c

And press Enter.

Euro Symbol in Excel - Method 4 - Step 4d

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.

Example #1

The table below lists sales representatives at a firm and their average monthly and annual salary figures.

Excel Euro Symbol - Example 1

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.
Example 1 - Step 1a

[ Alternatively, select the required cell range and choose Home Number Format More Number Formats.

Example 1 - Step 1b

Otherwise, select the required cell range and click the Number Format dialog box launcher icon in the Home tab.

Example 1 - Step 1c

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.
Example 1 - Step 2a

And select the required negative numbers settings in the Negative numbers field.

 Example 1 - Step 2b

Finally, click OK in the Format Cells window to view the values in Euros in the chosen range.

Excel Euro Symbol - Example 1 - Step 2c

Thus, the data format of the chosen range changes from Number to Currency, though the underlying values remain the same.

Example #2

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.

Excel Euro Symbol - Example 2

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.
Example 2 - Step 1
  • Step 2: Choose the required VBA Project and select Insert Module to open a module window.
Example 2 - Step 2a
Example 2 - Step 2b
  • Step 3: Enter the VBA code in the module window to display the chosen values in the Euro currency format.
Example 2 - Step 3
  • Step 4: Click the play icon to run the code.
Example 2 - Step 4a

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.

Excel Euro Symbol - Example 2 - Step 4b

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)

1. How to remove Euro symbol in Excel?

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.

Euro Symbol in Excel - FAQ 1

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.

FAQ 1 - Step 1

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

FAQ 1 - Step 2a

FAQ 1 - Step 2b

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.

Euro Symbol in Excel - FAQ 1 - Step 2c

2. Why the Euro symbol does not display in Excel?

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.

3. How to insert Euro symbol in Excel on Mac?

We can insert Euro symbol in Excel on Mac using the keyboard shortcut Alt + Shift + 2.

Download Template

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 –

Reader Interactions

Leave a Reply

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