Forum Discussion
Date Formatting Won't Change
- Finally figured this out.
Change the date format of your computer from the taskbar.
Regardless of timezone and all, go to your task bar> click the time/date > region >then look for additional date, time & regional settings > change date, time and number formats> additional settings> then go to the date tab and you can manually set the format by using the MMM dd yyyy or whichever format you want it in. Restart your computer and it should work on excel.
Wew
In some cases, it seems Excel does not change the format even if all settings and everything is ok. I had YYYY.MM.DD (2025.08.06) and wanted DD. MMM YYYY (26 aug 2025). If I activated a cell and tab'ed out, the format changed, but I had 1000s of lines and did not bother. Solution: Mark row, replace all point with point, and then format changed as it should. It seemed that Excel had to "reinterpet" all cells before changing format. There might be other ways, but this worked.
2025-09-11 - Still not working for me. I have tried all the solutions listed. (YES I really did try them all) But still no solution.
It should be simple. Convert this format "2/13/2024" to this format "2024/02/13" As I want to be able to sort all the dates from my downloaded Bank data in the YYYY-MM-DD format so that they all sort correctly for the whole year. *I still don't understand how the banking industry has not changed their format to correct this obvious sorting issue. (rant over)
What do you have exactly, text ("2/13/2024") which looks like a date; or date (2/13/2024) which is actually integer number (45335 if to apply General format)?
