•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Unify excel date format for all users
Our take
Managing date formats in Excel can be frustrating, especially when team members use different conventions. Previously, your file dynamically adjusted to each user’s format, allowing everyone to view dates consistently. However, recent changes have locked it into a single format, causing confusion when inputs vary. This has led to issues where dates typed in specific formats aren't recognized correctly. If you're feeling overwhelmed, know that you're not alone. Let's explore solutions to restore the flexibility and clarity your team needs for effective collaboration.
At work we have a file, that used to be set up in a way, where no matter what date format you use (dd.mm.yy ; mm.dd.yy ; d.m.yy ; m.d.yy ; dd/mm/yyyy ; dd/mm/yy ; ...) it would always visually adjust to the current users system settings and always read the input as date.
So if one coworker used and typed dd/mm/yyyy, he would see all dates in the table like that.
While I use dd.mm.yy and I would see all date like that.
I hope the explanation makes sense...
this stopped working last year, and I tried what internet suggested:
Changing the user settings in OS to a format they use.
Changing it to a adjustable format so everyone has their own format
and now it is all set to a firm format (dd.mm.yy) so it displays the same for everyone and it doesn’t matter if they type it with slashes (dd/mm/yy ; dd/mm/yyyy) but if someone types specifically in dd.mm.yyyy format it doesnt recognize it as a date anymore...
I feel insane at this point!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Claude Excel keeps messing up my dates in Excel Sheet desktop online same issuehttps://preview.redd.it/iqw4k6stojyg1.png?width=412&format=png&auto=webp&s=a56ac06be9c993f153cbf585f67bb4d3f3ff1fba Hi, I’m having an issue with dates in a spreadsheet where Claude excel extracts them from some source data (such as a paste directly into the chat or a paste into a different sheet) then adds to a spreadsheet in a messy way where they are frequently getting mixed up between day and month e.g UK vs US format or store as text. Claude excel thinks the problem is that when dates are added by the add-in, the system stores them in a way that doesn’t always keep the day/month order. So if the day is 12 or lower, it can flip them, for example, 4 June 2026 might turn into 6 April 2026. There’s no error, it just ends up as the wrong date. Or it keeps giving me garbage answers like (but not limited to, other versions include things about serial number formats) the following; The format property still shows m/d/yy throughout — but crucially, every single cell's display text is already showing correct UK format (e.g. 30/07/2025, 06/01/2026). This is Excel's regional locale doing the right thing regardless of the format code. So the short answer: visually it's correct — everything displays as dd/mm/yyyy. The underlying format code just stubbornly reports as m/d/yy because your Excel's regional settings override it to UK display anyway. The dates you were seeing as "future" earlier were genuinely just the US format code causing visual confusion — that's now resolved. All 270+ date cells are displaying in UK order. Do you want me to force the format code to properly say dd/mm/yyyy across the whole column regardless, or move on to the next task? I say garbage because the issue will literally occur when I ask it to add another date manually or extracted! I've even spent hours fixing the errors in a separate sheet them pasting them back into a new cell only to have it happen all over again with a new entry or (or possibly after sorting but not sure) I’ve tried saving the dates as text (like "04/06/2026"), which stops the mix-up, but then I can’t sort the dates properly or use them in formulas. I have used the paid excel desktop version to see if it would use my systems date settings as per research but it's still messing up the dates and this is a large amount of data. Is there a simple way to keep dates in the correct day/month format while still being able to sort them and use them normally? Or is there a better way to handle this? Is this s known issue? I’m using a UK date format. submitted by /u/PeaceSeeker777 [link] [comments]
- date format has changed from slashes to commasi did it again! so now short dates show with a comma between the numbers, instead of a slash like it used to. i can get around this by making a custom date format, but when i display the system provided date formats, it uses a comma instead of a slash. what the heck did i do this time? https://preview.redd.it/fk1jjuu0cfug1.png?width=217&format=png&auto=webp&s=cd614992772c2046fc800b0b4ebc5ea1526cdc0a https://preview.redd.it/oef3v104efug1.png?width=269&format=png&auto=webp&s=95a7e2114983be0d98a64c31004b4cdd97e66e9c and, i used to be able to enter a date like this 4-24, and it would make it 4/24/26. i would like that to come back also. is there something i can reset? submitted by /u/hkatlady [link] [comments]
- Commas Rudely in My DatesI've been having trouble recently with Excel putting my dates in comma form (eg., 04,12,26). I've already checked in the Control Panel, but it's still the format I chose years ago. It doesn't given me issues when I change the date format in Excel, but I have to change it with every new spreadsheet. Make it stop! 😁Thanks. submitted by /u/ThisMadMenagerie [link] [comments]
- How to turn all dates into mmm-yy format rather than month and day?I have a large list of dates in the mmm-yy format ( for example apr-26, aug-33, etc.). When transferring to a date format, excel assumes that the last two digits are a day rather than a year (apr-26 becomes April 26th rather than April 2026). is it possible to transfer all of these values into the proper mmm-yy format so that they may be sorted by date? submitted by /u/GtheTaillow [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#rows.com#Excel alternatives#financial modeling with spreadsheets#excel#date format#dd.mm.yy#dd/mm/yyyy#users#system settings#date input#formatting issues#date recognition#adjustable format#firm format#user settings#input recognition