Fix Formula Separators and Date Formats in Excel for Mac
Question details
The user needs to correct comma versus semicolon formula separators and resolve date display or calculation issues in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user is working with formulas and dates after changing regional or date-format settings on a Mac.
- Observed behavior
- Excel formulas may reject commas or semicolons, and dates may appear incorrectly, remain as text, or calculate using an unexpected date system.
Close and reopen Excel after changing macOS regional settings, because Excel reads separator conventions from the system locale. Check a few affected cells to determine whether they contain actual dates or text that only looks like a date.
Set the correct macOS region for Excel formula separators
Use this when Excel expects semicolons instead of commas, or when the date order and separator follow the wrong regional convention.
Excel for Mac generally follows the macOS regional format. A region that uses a decimal comma commonly uses semicolons between formula arguments, while regions using a decimal point commonly use commas.
Select the Apple menu, choose System Settings, then open General > Language & Region.
Set Region to the country or region whose date order, decimal symbol, and list separator you need. Review the displayed date and number formats before closing System Settings.
Quit Excel completely, reopen the workbook, and enter a simple formula such as =SUM(A1,B1). If Excel expects semicolons in your selected region, enter =SUM(A1;B1) instead.

Convert text entries to real Excel dates and apply a date format
Use this when date values do not sort, calculate, or change correctly after you apply a new cell format.
Match the workbook date system when dates are offset
Use this when every calculated or imported date is consistently wrong by approximately 1,462 days.
Work with Excel formulas and dates in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative for working with spreadsheets when you need a familiar interface and reliable file exchange. WPS Spreadsheet supports common formula and date-format tasks while helping you move seamlessly between Microsoft Excel files and your Mac workflow.
- 1. Install WPS Office: Download and install WPS Office on your Mac, then open WPS Spreadsheet from the WPS Office home screen.
- 2. Open the Excel workbook: Select Open and choose the XLSX or XLS workbook that contains the formulas or date values.
- 3. Review formulas and date cells: Select affected cells, edit formulas in the formula bar, and use the Home tab number-format controls to apply the needed date display.

Frequently Asked Questions
Why does Excel for Mac use semicolons instead of commas in formulas?
Excel for Mac follows the macOS regional format. Open Apple menu > System Settings > General > Language & Region and check the selected Region. Regions using decimal commas commonly require semicolons between formula arguments.
Can I change a date format without changing the stored date value in Excel?
Yes. Select the date cells, press Command+1, choose Number > Date or Custom, and select the display format. This changes how a real date is shown, not the underlying date value.
Why does changing the date format not fix my Excel dates?
The cells may contain text rather than real date serial values. Select the column, use Data > Text to Columns, choose the correct Date order such as DMY or MDY, then apply the preferred format.
Why are my Excel dates off by 1,462 days on a Mac?
The workbook may use a different date system. In Excel, open Excel > Preferences > Calculation and check Use 1904 date system. Match this setting to the workbook or source file you are using.




