how to change decimal separator in excel mac

Click Start, type 'control', select Control Panel App, select Region, select Additional Settings. Follow the tutorial below to change Excel's decimal separator options: 1. Hi betooonc - its a Windows setting, not an Excel setting.

Working with international data in Excel configured in Portuguese can be a real nightmare.ĭecimal separators for English-speaking countries such as the USA, UK and Australia are different from the decimal separators for European countries and some Latin American countries, for example Brazil.The former use dot as decimal separator (19.99) and comma as thousands delimiter (2,999.50).Others use the comma as the decimal separator (19.99) and the period as the thousands delimiter (2999.50).By default, Excel gets Windows language separator settings and changing these settings may cause unexpected errors in other applications, but don't worry, Excel allows you to make this change directly in your settings.

two.Select Advanced Options In the new window, look in the left side menu for 'Advanced'.

When working or importing data into Excel spreadsheets from web pages, systems or CSV files, Excel may recognize some numbers and convert them to standard text type.Changing even temporarily the Excel settings helps to reduce the amount of manual work and the number of errors in replacing comma by period, semicolon, semicolon by comma, etc. Follow the tutorial below to change Excels decimal separator options: 1.Enter Options In the 'File' tab, click the 'Options' button, a new window will appear.

How to change decimal separator in excel mac