There are many ways to write out various numbers and dates, and their format will vary depending on your region. =VLOOKUP('Photo frame' A2:B16 2 FALSE) Writing numbers and dates =VLOOKUP('Photo frame', A2:B16, 2, FALSE)īut in many countries, arguments must instead be separated by a semicolon, like this: English version-arguments in a formula are separated by a comma, as in the example below: In many versions of Excel-including the U.S. Let's take a look at some of the most important things that can vary if you're using Excel in another language or version.
English version of Excel in our Microsoft Office tutorials, so you may notice that some things work slightly differently in your version. However, there are also many regional differences when it comes to certain tasks in Excel, including separating arguments, writing numbers, and function names.įor example, we use the U.S. And because Excel is popular around the world, it's available in many different languages and versions. Millions of people use Microsoft Excel to organize and calculate data. en/excel-tips/free-resources-for-learning-office-for-mac/content/ Understanding regional differences in Excel
Lesson 28: Understanding Regional Differences in Excel
