Euro Symbol in Excel
In MS Excel, there are various ways to enter the ‘EURO’ symbol and the usage of the symbol. Here we discuss top 5 methods to type Euro Symbol along with examples
#1 – Using Shortcut Key
We can use a shortcut key to insert the ‘EURO’ symbol in the cell of MS Excel. The shortcut key is ‘Alt+0128’. We need to press the keys for ‘0’, ‘1’, ‘2’, and ‘8’ while pressing ‘Alt’ key to enter the ‘EURO’ symbol in the cell.
#2 – Using ‘CHAR Function’
‘CHAR Function‘ is one of the text function. This function outputs character specified by the code number from the character set of the computer. We can also this function to insert the line break. For line break, we need to use the ’10’ number as an argument to this function. This function can also be used in VBA code for the application.
If we discuss the syntax of the ‘CHAR Function’, it is as follows:
#3 – Argument of the Function
Number: We need to specify the number from 1 to 255 as per the character set of the computer. If we specify a number less than 1 or greater than 255, this function returns #VALUE error.
To generate ‘EURO Symbol’ using the ‘CHAR Function’, the syntax is as follows:
We need to use ‘128 number’ as an argument to the function to generate ‘EURO Symbol’. We will close the parenthesis for the function and get the output.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
#4 – Using the ‘Insert’ Tab
There is a command named ‘Symbol’ available in the ‘Symbols’ group under the ‘Insert’ tab.
We can use this command to insert various types of symbols, which is not available on our keyboard.
- First, we need to select the cell where we want to insert the ‘EURO’ symbol and then click on this command.
- A dialogue box named ‘Symbol’ will open where we can choose our desired ‘EURO’ Choose ‘Arial’ for the ‘Font’ and ‘Currency Symbols’ for ‘Subset’ so that we can have ‘EURO’ symbol as an option in the list to choose. We need to click on the ‘Insert’ button to insert the ‘EURO’ symbol in the cell.
- After clicking on the ‘Insert’ button, we get the result as follows:
#5 – Using the ‘Replace’ Method
In this method, we make changes in the settings of the application so that whenever we type some specified phrase, the text is replaced with the specified text, which we have specified in the settings. In our example, we need to replace the text with the ‘EURO’ symbol. To do the same, we will take the following steps:
- We will click on the ‘File’ tab from the ribbon.
- We will choose ‘Options’ from the menu.
- From the menu on the left side of the ‘Excel Options’ dialogue box, we will choose ‘Proofing’.
- We now need to click on ‘AutoCorrect Options’ to add an entry into the list to replace the specified phrase with the specified phrase.
- We need to choose the ‘AutoCorrect’ tab from the tabs to add the entry.
- We need to specify the replacement entry as below:
- We need to click on the ‘Add’ button to add the entry into the list and then click on ‘OK’.
Now whenever we type ‘EURO’, the word is automatically replaced with ‘EURO Symbol (€)’.
We can also use the EURO symbol to format the number as currency as required.
Euro Symbol in Excel – Examples
Suppose, we have the following data for sales of an organization for 3000 rows.
As we can see in the above data that data in ‘Unit Price’, ‘Unit Cost‘, ‘Total Revenue’, ‘Total Cost’ and ‘Total Profit’ column is in number format. We need to format this data as the currency of EURO; otherwise; it is not accurate for the user to view the data in this format.
To do the same, we need to follow the steps mentioned below:
- We need to select a column from column H to column L as this data is related to the currency.
- We need to open the ‘Format Cells‘ dialogue box using the arrow on the right-bottom corner of the ‘Number’ group or to use a shortcut key which is ‘Ctrl+1’.
- We need to click on the ‘Number’ tab and then choose ‘Currency’ from the list on the left side to get the list of various currencies to choose from.
As we have to apply the format for ‘EURO’ currency, we will choose the same from the list for ‘Symbol’.
- We will click on the ‘OK’ button to apply the format for the ‘EURO’ currency for the selected data.
The data is the format as currency using the EURO symbol. We could also use the VBA code to format the data as currency in the EURO symbol.
Suppose we have the same data as in Example 1. However, this time, we will be using the VBA code to format the data as currency using the EURO symbol.
To format the number as the currency of EURO using VBA code, we need to take the following steps:
- Using either ‘Visual Basic’ command available in the ‘Code’ group on the ‘Developer’ tab or using a shortcut key which is ‘Alt+F11’, we will open the ‘Visual Basic Editor‘.
- Click on ‘ThisWorkbook’ from the list on the left side of the Visual Basic Editor to write the code.
- We need to define a subroutine so that whenever we select the required range and run this macro, the data is formatted as a currency of €.
Sub FormattingDataAsEuroCurrency() Dim cell As Range For Each cell In Selection cell.NumberFormat = "€ #,##,###.00" Next End Sub
- Quit the ‘Visual Basic Editor’ using a shortcut key, which is ‘Alt+Q’.
Now we need to select the range from I2:M3000 and run the macro using the ‘Macros’ command available in the ‘Code’ group under the Developer tab.
The data is formatted.
Things to Remember
- Make sure that the Excel workbook with VBA code is saved with an extension of .xlsm extension as otherwise, we would not be able to run the VBA code.
- While entering the EURO symbol using the Alt+0128 shortcut key, make sure that the ALT key is continuously pressed while pressing number keys, which are 0, 1, 2, and 8.
This has been a guide to Euro Symbol in Excel. Here we discuss the top 5 methods to type euro symbol along with examples. You may also look at these useful excel tools –