Excel guide · 5 min read
How to insert the euro symbol (€) in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Expense | Amount (typed) | Amount (number) | From a German report | |
| 2 | Hotel, Lisbon | €1,240.00 | 1240 | 1.240,00 € | |
| 3 | Flights | €389.99 | 389.99 | ||
| 4 | Train to Porto | €64.50 | 64.5 | ||
| 5 | Client dinner | €212.80 | 212.8 | ||
| 6 | Taxis | €38.00 | 38 | ||
| 7 | Conference pass | €1,495.00 | 1495 | ||
| 8 | Total | 3440.29 |
Download this sheet as an Excel practice file (.xlsx)
Keyboard shortcuts for €, £, ¥ and other symbols
Alt codes work in any Windows program, Excel included. Turn Num Lock on, hold Alt, type the four digits on the numeric keypad and let go of Alt. The number keys along the top of the keyboard don't work for this, which is why the trick seems broken on many laptops.
- € euro: Alt+0128 on Windows. AltGr+E on German, French and many other European keyboard layouts; AltGr+4 on a UK layout.
- £ pound: Alt+0163 on Windows. Shift+3 on a UK layout.
- ¥ yen: Alt+0165 on Windows.
- ¢ cent: Alt+0162 on Windows.
- On a Mac with a US keyboard: Option+Shift+2 for €, Option+3 for £, Option+Y for ¥.
My laptop has no numeric keypad. What now?
Use Insert > Symbol (below), or a formula. In Windows Excel, CHAR uses the Windows character set, where code 128 is the euro sign, so =CHAR(128) returns €. Copy the cell and paste it as a value if you need the plain character.
Result: €
€, the euro sign (code 128 in the Windows character set).
Insert > Symbol when you can't remember the code
The Currency Symbols subset also has ₹, ₩, ₺ and other signs that have no Alt code. Once you've inserted a symbol, it appears in the Recently used symbols row, so the next time is one click.
A symbol inserted this way is text. Typed into an empty cell together with digits, you get a text value like "€1,240", which brings its own problem (the last section).
- Click the cell, or click in the formula bar where the symbol should go.
- Go to Insert > Symbol (in the Symbols group at the right of the ribbon).
- Leave Font on (normal text) and choose Currency Symbols in the Subset list.
- Click €, then Insert, then Close.
Format amounts as euros instead of typing the symbol
For money, the symbol belongs in the number format, not in the cell. The cell keeps the number 1240, shows €1,240.00, and SUM, sorting and charts all work.
- Select the amounts.
- On the Home tab, in the Number group, click the arrow next to the Accounting Number Format button (the currency icon).
- Choose € Euro (€ 123). For another currency, click More Accounting Formats and pick it from the Symbol list.
Accounting or Currency format: which one?
Both keep the value numeric. Accounting lines the € up at the left edge of the cell and shows zero as a dash, which suits financial statements. Currency puts the € right next to the number. Press Ctrl+1, open the Number tab, choose Currency and pick from the Symbol list, which has both € 123 and 123 € variants.
Can I write my own € format?
Yes. In Ctrl+1 > Number > Custom, type "€"#,##0.00 for €1,240.00 or #,##0.00 "€" for the symbol after the amount. The quotes tell Excel the € is literal text in the format. TEXT accepts the same codes when you need an amount inside a sentence.
Result: Trip total: €3,440.29
Trip total: €3,440.29. The doubled quotes are how you put a quote inside a formula's text.
Fix typed "€1,240.00" amounts that won't add up
When amounts arrive as text, from a typed list, a web page or an export, SUM silently skips them. Column B in the sample looks like money but every cell is text, so =SUM(B2:B7) returns 0. The tell: text sits on the left of the cell, real numbers sit on the right.
Strip the symbol and the thousands comma, then turn what's left into a number: =VALUE(SUBSTITUTE(SUBSTITUTE(B2,"€",""),",","")) in C2, filled down. Format column C as € Euro and you have real numbers again. Numbers stored as text covers other causes.
Result: 3440.29
3440.29: the six expenses added up once the text is converted. =SUM(B2:B7) on the original column returns 0.
What about European-style amounts like 1.240,00 €?
There the dot groups thousands and the comma is the decimal point, so removing commas would be wrong. NUMBERVALUE (Excel 2013 and later) lets you say which is which: =NUMBERVALUE(SUBSTITUTE(E2,"€",""),",",".") reads 1.240,00 as 1240. It also ignores the spaces around the number.
Can I fix the column in place instead?
Yes. Select it, press Ctrl+H, put € in Find what, leave Replace with empty and click Replace All. Excel re-reads each cell, and in a locale that uses a comma for thousands "1,240.00" becomes the number 1240. Then apply the € format. More fixes are in numbers stored as text.
Common mistakes
Typing the € into every amount
Type plain numbers and apply a € number format. Typed symbols turn amounts into text that SUM ignores.
Using the top-row number keys for Alt codes
Alt codes need the numeric keypad with Num Lock on. Without one, use Insert > Symbol or =CHAR(128).
Converting exchange rates by changing the symbol
Switching the format from $ to € only relabels the number. To convert, multiply by a rate, as in convert currency in Excel.
Removing commas from European amounts
In 1.240,00 the comma is the decimal point. Use NUMBERVALUE with "," as the decimal separator instead.
FAQ
What is the Alt code for the euro sign in Excel?
Alt+0128, typed on the numeric keypad with Num Lock on. It works in cells and in the formula bar, and in other Windows programs too.
How do I change the dollar sign to euro in Excel?
Select the cells, click the arrow next to the Accounting Number Format button on the Home tab and choose € Euro (€ 123). The values don't change, only how they display.
Why can't I sum numbers with a € sign?
They were typed or imported as text, so SUM skips them. Strip the symbol with SUBSTITUTE and convert with VALUE, or remove the € with Find and Replace, then apply a € format.
How do I type the pound sign in Excel?
Shift+3 on a UK keyboard, or Alt+0163 on the numeric keypad on any Windows keyboard. For amounts, use the English (United Kingdom) £ option on the Accounting Number Format arrow instead.
Functions used
CHARCharacter from its code numberTEXTNumber to formatted textVALUEText to numberSUBSTITUTEReplaces textSUMAdds numbers
Related guides
- Accounting vs Currency format in Excel: what's the difference?
- How to insert the degree symbol in Excel
- How to convert currency in Excel
- How to convert numbers stored as text in Excel
- How to superscript and subscript in Excel
- How to concatenate with a space in Excel (CONCAT and &)
Updated