International and multilingual Excel help

International Excel Function Names

Understand how Excel function names, separators, and date formats can change across languages and regions.

What changes by language or region

  • Some Excel installations translate function names, while Excel for the web and many documentation sources use English names.
  • Argument separators can be commas or semicolons depending on regional settings.
  • Date formats can change the meaning of imported values, especially between month/day/year and day/month/year regions.

How to avoid international formula issues

  • Confirm whether your Excel version expects commas or semicolons before copying formulas from the web.
  • Use DATE(year, month, day) instead of typed date strings when formulas must be portable.
  • When sharing files globally, document the intended locale and Excel version.

Cross-locale workbook workflow

  • Maintain an English-to-local function translation sheet when teams share files across countries.
  • Open sample formulas in both locales on a test machine before mass find-replace on function names.
  • Separate calculation sheets from presentation sheets when only one locale must edit formulas.
  • Export PDF snapshots for sign-off when formula language differs from reviewer UI language.

Recommended next steps

  • English VLOOKUP may appear as PROCV (Portuguese), SVERWEIS (German), or BUSCARV (Spanish) in localized Excel.
  • When sharing files across locales, keep a translation sheet mapping English names to local equivalents.
  • Array formulas and dynamic functions may differ in availability between Excel desktop builds and Excel for the web.
  • Bookmark the English function directory pages even if your UI shows translated names — search indexes use English terms.

Common localization pitfalls

  • Argument separators: comma vs semicolon depending on regional Excel settings.
  • Decimal separators in nested criteria strings — test SUMIFS criteria from cells instead of literals.
  • Dynamic arrays may show #NAME? on Excel 2019 even if the English name is spelled correctly.
  • External links break when path or locale changes — refresh links after moving files.

People also ask

  • Why does my English formula show #NAME? in another country? Function or separator localization — compare against the translation sheet.
  • Can I force English function names? Depends on Excel language pack; document the locale each template supports.
  • Where to find English syntax? This directory uses English names regardless of your UI language.

Deep-dive function map for International Excel Function Names

  • DATE (/functions/date/): Creates a date from year, month, and day components. Example: =DATE(2026, 1, 21).
  • TEXT (/functions/text-function/): Converts a value to text in a specified number format. Example: =TEXT(1234.5, "$#,##0.00").
  • VALUE (/functions/value/): Converts a text string that represents a number to a number. Example: =VALUE("123").
  • NUMBERVALUE (/functions/numbervalue/): Converts text to a number in a locale-independent way. Example: =NUMBERVALUE("1.234,56", ",", ".").
  • TEXTJOIN (/functions/textjoin/): Joins text from multiple ranges with a delimiter, with option to ignore empty cells. Example: =TEXTJOIN(", ", TRUE, A1:A10).

Two-week study plan

  • Week 1 — Read each related function page and copy one example per function into a practice Table.
  • Week 2 — Apply this guide to a real export from your job; document fixes in a changelog tab.
  • Explore categories: Date & Time, Text.
  • Run the fix-excel-formula-errors checklist when any formula shows #N/A, #VALUE!, #REF!, or #SPILL!.
  • Compare similar functions (VLOOKUP vs XLOOKUP, SUMIF vs SUMIFS) before standardizing team templates.
  • Export a PDF snapshot of your completed practice workbook for future reference and onboarding.

Error and troubleshooting cross-links

  • Fix #NAME? (/errors/name?/) — step-by-step causes and solutions in the error directory.
  • Fix #VALUE! (/errors/value-error/) — step-by-step causes and solutions in the error directory.