'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Recent Files Showing Wrong Date Format
Question details
The user is experiencing an issue where the modification dates in the Excel recent files list do not match their custom system date format.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Viewing the recent files list when opening Microsoft Excel.
- Observed behavior
- The recent-file list displays file modification dates based on the default Windows regional language setting rather than respecting the custom system date format.
Ensure you have administrative privileges on your Windows computer, as modifying regional settings will affect the date and time format across your entire system.
Adjust Windows Regional Language Settings
Since Excel's recent files list relies on the default regional language rather than custom formats, you must change your overall Windows region setting to match your preferred date style.
The Microsoft Office interface is designed to pull date formatting directly from the primary Windows Regional Language presets. Customizing the date format manually in the Control Panel does not always override this behavior in the Office UI.
Click the Windows Start menu and select the gear icon to open Settings, then navigate to Time & Language.
From the left sidebar, select Region or Language & region.
Under the Regional format dropdown, select a country whose default date format matches your preference. For example, choose English (United States) for MM/dd/yyyy, English (United Kingdom) for dd/MM/yyyy, or English (Canada) for yyyy-MM-dd.
Close all instances of Excel and reopen the application to view the updated date formats in your recent files list.
Format Dates Inside Worksheet Cells
If you also need to fix how dates appear inside your actual spreadsheet cells, you can apply a custom number format directly in Excel.
Try WPS Office for a Seamless Spreadsheet Experience
If you frequently encounter interface limitations and configuration issues in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for viewing, editing, and managing your spreadsheets without the heavy system configurations.
Frequently Asked Questions
Why does Excel ignore my custom Windows date format in the recent files list?
Excel's recent files interface is programmed to read the default date format associated with the primary Windows Regional Language setting. It frequently ignores localized custom modifications made within the Windows Control Panel.
Can I change the recent files date format without changing my entire Windows region?
Currently, Microsoft Office does not offer an in-app setting to isolate the recent files date format from the overall Windows regional language setting. You must adjust the system region to force a change.
How do I get the yyyy-MM-dd format in my recent files list?
You can achieve this by changing your Windows Regional format to English (Canada) in the Time & Language settings, as this region uses the yyyy-MM-dd format natively.
Will changing the Windows region affect my existing Excel spreadsheets?
Changing the region will affect how default dates are displayed system-wide and in new spreadsheets. However, cells that have been strictly formatted with a custom number format (like yyyy-MM-dd) will remain unchanged.
