Office for Mac Issues

Fix Excel Date Format Not Staying as YYYY-MM-DD on Mac

Maira Mehtab Sep 22, 2026 869 views

Question details

Users are unable to keep the YYYY-MM-DD date format in Excel for Mac, with dates reverting to default formats like 01/31/2025 despite macOS system settings.

Product: Excel for Mac
Device & OS: macOS
Scenario: Importing data or applying custom date formats to a spreadsheet on a Mac.
Observed behavior: Excel displays dates in the MM/DD/YYYY format instead of the desired YYYY-MM-DD format, typically because the imported values are stored as text strings rather than actual date numbers.

Before you start

Verify your current version of Office for Mac and ensure your macOS Language & Region settings are configured to your preferred date format.

Solution 1Recommended

Convert Text to Dates and Apply Custom Formatting

Use the Text to Columns feature to convert text strings into valid dates before applying the YYYY-MM-DD format.

Applying a custom number format will not work if the cells are formatted as text. You must first convert the text values into real date values recognized by Excel before the custom formatting can take effect.

Select the Data

Highlight the column or cells containing the dates that will not format correctly.

Use Text to Columns

Navigate to the 'Data' tab on the ribbon and click on 'Text to Columns'.

Configure the Wizard

Choose 'Delimited' and click 'Next' twice. In the third step, select 'Date' under Column data format, choose the format that matches your current text (e.g., MDY), and click 'Finish'.

Apply Custom Format

With the dates still selected, press 'Cmd + 1' to open the Format Cells dialog. Go to the 'Number' tab, select 'Custom', type 'yyyy-mm-dd' in the Type box, and click 'OK'.

Format Applied: Your dates are now stored as numbers and will correctly display in the YYYY-MM-DD format regardless of the original import style.

Solution 2

Update macOS System Date Settings

Change the default macOS region and language settings so Excel automatically recognizes your preferred date format.

Format Dates Seamlessly

Manage and Format Dates Consistently with WPS Spreadsheet

Avoid frustrating formatting issues by using WPS Spreadsheet. It offers intuitive data conversion tools and custom formatting options that work seamlessly and identically across Mac and Windows.

1. Open Your Spreadsheet: Launch WPS Office and open your .xlsx file containing the imported dates.
2. Convert the Text: Select your date column, go to the 'Data' tab, and click 'Text to Columns' to convert text strings to valid dates.
3. Format the Cells: Right-click the selected cells, choose 'Format Cells', and navigate to the 'Custom' category.
4. Apply YYYY-MM-DD: Type 'yyyy-mm-dd' into the format box and click 'OK' to instantly update your date displays.

Easily convert imported text to standard dates using the built-in Text to Columns feature.Apply custom YYYY-MM-DD formats with just a few clicks.Fully compatible with Microsoft Excel (.xlsx) file formats and date structures.Free, lightweight, and easy-to-use Office alternative for Mac users.

microsoft office alternative - wps office

Frequently Asked Questions

Why won't Excel change my date format on Mac?

This usually happens because imported dates are recognized as text strings rather than numeric values. Cell formatting only changes the visual display of numeric dates, so text strings will remain unchanged until converted to numbers.

How do I know if a date is stored as text in Excel?

By default, text values align to the left side of a cell, while valid dates (which are stored as numbers) align to the right. You can also use the ISTEXT() function to check if Excel recognizes the cell contents as text.

Can macOS system settings override Excel date formats?

Yes, Excel often pulls default short and long date formats directly from your macOS Language & Region settings. Changing these system settings and restarting Excel can resolve default formatting issues, though custom formatting applied inside Excel will take precedence.

Office App Problems