•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Commas Rudely in My Dates
Our take
If you've been frustrated by Excel's stubbornness in displaying your dates as commas (e.g., 04,12,26), you're not alone. Despite your attempts to adjust settings in the Control Panel, Excel seems to cling to an outdated format, requiring you to change it manually for every new spreadsheet. This repetitive task can hinder your productivity and disrupt your workflow. Fortunately, there are solutions to help you regain control over your date formatting. Let's explore how to resolve this issue and streamline your experience with Excel.
I'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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Unify excel date format for all usersAt 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! submitted by /u/Expert_Plankton_7561 [link] [comments]