Office for Mac Issues

Fix Excel for Mac Not Applying Number and Date Formats

Maira Mehtab Sep 28, 2026 869 views

Question details

The user is unable to apply date or other number formats to cells in Excel for Mac, even when using entirely new, blank workbooks.

Product: Microsoft Excel for Mac
Device & OS: macOS Sequoia
Scenario: Attempting to format cells with dates and numbers after installing Microsoft 365 on a Mac.
Observed behavior: Excel ignores applied number and date formats. The issue can affect all cells globally or only newly added rows, persisting despite reinstallations or version rollbacks.

Before you start

Verify that your Mac's operating system is fully updated to the latest version of macOS Sequoia and ensure you are testing the formats in a completely fresh, blank workbook.

Solution 1Recommended

Adjust macOS Regional and Date Settings

macOS system-level regional settings control how applications handle dates. Aligning these with Excel resolves formatting conflicts.

Excel for Mac relies heavily on the macOS system preferences to interpret date and time inputs. If the format you type into Excel differs fundamentally from the regional standard set in macOS, Excel may fail to recognize the input as a date, treating it as unformatted text.

Open System Settings

Click the Apple menu in the top-left corner of your Mac and select 'System Settings'.

Navigate to Date & Time

Click on 'General' in the sidebar, then select 'Date & Time' to view your current regional configurations.

Verify Regional Formats

Ensure the system's regional date format matches the format you are typing into Excel (e.g., day/month/year vs. month/day/year).

Create a Custom Format in Excel

Highlight the affected cells in Excel, press Command+1 to open 'Format Cells', choose 'Custom', and manually define the format (such as dd/mm/yyyy) to force the display.

Testing Formats: Always test with simple dates first (like 1-Jan-2024) to see if Excel automatically converts them based on the new system settings.

Solution 2

Disable Add-ins and Boot into Mac Safe Mode

Third-party extensions or system background processes can interfere with Excel's formatting engine.

Solution 3

Clear Table Styles and Conditional Formatting

If formatting only fails on newly added rows, existing table rules might be overriding your manual format choices.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Formatting on Mac

If Microsoft Excel continues to experience formatting glitches or refuses to apply number and date formats on your Mac, WPS Office is the perfect solution. It provides a lightweight, fast, and highly compatible alternative without the frustrating system-level conflicts.

1. Download the Mac Installer: Visit the WPS Office website and download the free macOS installation package.
2. Install and Launch: Open the downloaded package, follow the simple installation prompts, and launch WPS Spreadsheets.
3. Open Your Files: Drag and drop your problematic .xlsx files directly into WPS Office to instantly edit and apply cell formats.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and formatting rules.Free, lightweight, and optimized for fast performance on macOS.Intuitive and familiar interface, making it incredibly easy to format dates, numbers, and custom cells.Seamlessly migrate your existing spreadsheets without losing any data or styling.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel on Mac change my dates to random numbers?

Excel fundamentally stores dates as sequential serial numbers (e.g., January 1, 1900, is serial number 1). If a cell containing a date is accidentally formatted as 'General' or 'Number' instead of 'Date', Excel will display the underlying serial number instead of the readable date format.

How do I force a custom date format in Excel for Mac?

To force a specific format, select the cells, press Command+1 to open the 'Format Cells' dialog box, navigate to the 'Number' tab, select 'Custom' from the category list, and type your desired format string (like 'dd/mm/yyyy' or 'mm-dd-yy') into the Type box.

What should I do if a completely new blank workbook still refuses formats?

If formats fail even in a brand new blank workbook and testing in Mac Safe Mode does not resolve the issue, the installation or the user profile may be deeply corrupted. You should verify your macOS regional settings, ensure your time zone is correct, and if all else fails, contact Microsoft Support for advanced diagnostics.

Office App Problems