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.