Office for Mac Issues

Fix Formula Separators and Date Formats in Excel for Mac

John WilsonJohn Wilson Nov 12, 2026 870 views

Question details

The user needs to correct comma versus semicolon formula separators and resolve date display or calculation issues in Excel for Mac.

Fix Formula Separators and Date Formats 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.
Before you start

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.

Solution 1Recommended

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.

1
Open Language and Region settings

Select the Apple menu, choose System Settings, then open General > Language & Region.

2
Choose the required regional format

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.

3
Restart Excel and test a formula

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.

Set the correct macOS region for Excel formula separators
Formula separator follows the locale: Changing a formula separator does not automatically rewrite existing formulas. Update formulas only if they were entered with a separator that does not match the current macOS region.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office on your Mac, then open WPS Spreadsheet from the WPS Office home screen.
  2. 2. Open the Excel workbook: Select Open and choose the XLSX or XLS workbook that contains the formulas or date values.
  3. 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.
Use familiar spreadsheet formulas, number formats, and date formatting tools.Open, edit, and save Microsoft Excel XLSX and XLS files.Use a lightweight Office suite with an interface designed for an easy transition from Excel.Manage regional date displays and spreadsheet formatting in compatible workbooks.
microsoft office alternative - wps office

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.