Show the thousands separator: Select the Thousands Separator tickbox.Lesson 28: Understanding Regional Differences in ExcelThe so-called CSV (Comma Separated Values) format is the most common. Specify how negative values appear: Click the pop-up menu to the right of the Decimals field and choose an option. Display as many decimal places as you type in each cell: Delete the number in the Decimals field, or click the Decimals down arrow until you reach the Auto setting.

However, there are also many regional differences when it comes to certain tasks in Excel, including separating arguments, writing numbers, and function names.For example, we use the U.S. And because Excel is popular around the world, it's available in many different languages and versions. Many other countries, such as those in the Euro zone use a comma instead./en/excel-tips/free-resources-for-learning-office-for-mac/content/ Understanding regional differences in ExcelMillions of people use Microsoft Excel to organize and calculate data.

For example, in the United States, decimal numbers are written with a period, as in the example below:But in many countries, decimal numbers are written with a comma, like this:There is a similar type of variation with numbers that use the thousandths place. English versionвЂ”arguments in a formula are separated by a comma, as in the example below:=VLOOKUP('Photo frame' , A2:B16 , 2 , FALSE)But in many countries, arguments must instead be separated by a semicolon, like this:=VLOOKUP('Photo frame' A2:B16 2 FALSE) Writing numbers and datesThere are many ways to write out various numbers and dates, and their format will vary depending on your region. Separating arguments in formulasIn 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.

Are usually written as month/day/year. For example, dates in the U.S. The same is true for calendar dates.

Excel For Mac Decimal Separator Box