FIX: Excel not changing the date format

by Vladimir Popescu
Vladimir Popescu
Vladimir Popescu
Managing Editor
Being an artist his entire life while also playing handball at a professional level, Vladimir has also developed a passion for all things computer-related. With an innate fascination... read more
Affiliate Disclosure
Excel not changing date format - laptop on table

To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

If your Excel software is not changing the date format, you have to know that you’re not the only one experiencing this issue.

This problem seems to be spread across a variety of platforms and versions of Excel, but don’t worry, we will give you step by step instructions to fix it.

Follow the steps presented in this guide carefully to avoid making any unwanted changes.

Try this method if Excel doesn’t change the date format

laptop with user typing - Excel not changing date format

  1. Click the Data tab from the top menu of your screen.
  2. Choose the Text to columns option from the menu.
  3. Tick the box next to the option Delimited to activate it.
  4. Press the Next button two times to move through the setup pages.
  5. Select Date -> click the drop-down menu -> choose the MDY custom option.
  6. Click the Finish button.
  7. Select any empty cell inside your Excel document -> press the Ctrl+1 keys on your keyboard.
  8. Select the Custom format option found at the bottom of the list.
  9. In the text box -> type YYYY/MM/DDD -> press Ok.

Can’t open Excel files in your browser? Fix it with these methods

Here’s how to change the Windows default date format

laptop with red Enter button - Excel not changing date format

Because in some cases the formats used for dates can be confusing, it is recommended that you change the default Windows date format to simplify the process in the long run.

Of course, this specific setting will depend on your requirements, but you can follow these steps to set it:

Press Win+R keys -> type control international -> press Enter.
Under the Formats tab -> check or change the default formats available.
Click the drop-down lists and choose the desired option.
Press Ok to save the settings.

Note: Changing the Windows date format settings will affect all the applications installed on your PC, and not only the options found in MS Excel.


In today’s how-to article we discussed the most efficient way of dealing with Excel not changing the date format.

If you found this guide helpful please don’t forget to let us know. You can do so by using the comment section found below this article.


idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.

This article covers:Topics: