EUROCONVERT Function in Microsoft Excel: Syntax, Examples & Troubleshooting

=EUROCONVERT(number, source, target, [full_precision], [triangulation_precision])

Number, source and target are required. Source and target are quoted three-letter currency codes or references containing them. Microsoft’s displayed syntax and argument labels call the last two inputs required, but its descriptions and examples explicitly allow omission; the brackets above show those documented omission behaviors.

full_precision defaults to FALSE, using currency-specific rounding. TRUE retains significant digits from the calculation. triangulation_precision, when supplied, is an integer at least 3 controlling intermediate euro precision. Omission leaves the intermediate euro value unrounded. This is a calculation setting, not merely a cell number-format choice.

The reviewed code list is BEF, LUF, DEM, ESP, FRF, IEP, ITL, NLG, ATS, PTE, FIM, GRD, SIT and EUR. Do not infer support for every current euro-area member’s historical code or for unrelated currencies such as USD from the general function description.

1. Enter 1.20 in A2, DEM in B2 and EUR in C2.
2. Enter =EUROCONVERT(A2,B2,C2) in D2.
3. Expected result: 0.61.

Microsoft’s example uses the fixed rate 1 EUR = 1.95583 DEM. The unrounded independent division is approximately 0.6135502574; the default euro rounding gives 0.61.

=EUROCONVERT(A2,B2,C2,TRUE) is expected to preserve approximately 0.6135502574 instead. Applying a two-decimal display format afterward can make it look like 0.61, but that does not make the underlying precision setting identical.

The reference supplies 1 EUR = 6.55957 FRF. For the documented 1-FRF control:

=EUROCONVERT(1,"FRF","EUR",TRUE,3)
=EUROCONVERT(1,"FRF","EUR",FALSE,3)
=EUROCONVERT(1,"FRF","DEM",TRUE,3)

Expected results are 0.152, 0.15 and 0.29728616, respectively. The third result is the intermediate euro amount 0.152×1.95583. This is a precision-controlled triangulation, not a fresh market FRF/DEM quotation.

Microsoft describes triangulation_precision as significant digits while its examples use the displayed three-place intermediate 0.152. These examples remain inside that documented fixture; they do not establish a new rounding rule for every scale of intermediate amount.

Keep original amount, original code, target code, full_precision choice and intermediate precision in separate columns. A default rounded result and a full-precision result can legitimately differ when many converted lines are summed. Decide whether the report rounds each line or only its final total rather than changing settings invisibly to force a match.

When source and target are the same, Microsoft documents that the original number is returned. =EUROCONVERT(12.345,"EUR","EUR") is therefore expected to return 12.345 as a value. The function does not apply a currency number format and truncates trailing zeros in its returned presentation.

The documented calculation/display decimal places are 0/0 for BEF, LUF, ESP and ITL; 0/2 for PTE and GRD; and 2/2 for DEM, FRF, IEP, NLG, ATS, FIM, SIT and EUR. Keep these differences in mind when comparing printed totals.

Invalid parameters produce documented #VALUE!. The function cannot be used in array formulas. If it gives #NAME?, Microsoft’s desktop instructions say to load Euro Currency Tools through File → Options → Add-Ins → Manage Excel Add-ins → Go, then select that add-in. Those are documented user steps, not an installation performed for this guide.

The reference’s broad product list does not establish identical add-in setup on every platform. Verify availability in the intended installation. No live exchange rate, account access or currency transaction is claimed here.

Microsoft’s reference checked on October 17, 2026 lists: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones. This current support list does not establish the first release. The introduction version and last functioning version have not been established from the reviewed documentation. No retirement is asserted.

Example verification: Expected numerical results are independently calculated; text and shape expectations follow the documented contract. These examples have not been tested in Microsoft Excel. No screenshot or native execution is claimed.

ROUND in Excel | SUM in Excel | VALUE in Excel

• Microsoft EUROCONVERT reference, retrieved October 17, 2026.