•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
DD MM YY format now working right
Our take
Are you struggling with sorting dates in Excel, particularly in the DD MM YY format? It can be frustrating when your spreadsheet doesn't cooperate, especially when organizing client contact dates from oldest to newest. This common issue often arises when Excel misinterprets date formats, leading to incorrect sorting. Fortunately, there are ways to resolve this problem and streamline your workflow. Let’s explore effective strategies to ensure your data is organized correctly, allowing you to manage your client list efficiently.
Can anyone help please I'm losing my mind at how uncooperative Excel is.
I've got a very extensive list of my client that I need to organise by date from when I last contacted them , oldest to newest , Format being Day month year , but every time I sort it it puts the newest day first then the older month , which makes no sense .
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- 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]
- How to change formatting of textHi everyone! I would like to ask for your help regarding the formatting of data in excel. So currently, I have list of dates however these dates are formatted as follows: MM/DD/YYYY ( example: 04/02/2024) I wanted to change the format to date to Month-Day-Year (02-Apr-2025) format but I dont know how to, Ive been trying to research about it. I have list of transactions and I really need to do it in bulk mode. Any suggest for a possible formula on this one? Help you Big 4 helpless dying auditor out. submitted by /u/flagrantly_mediocre [link] [comments]
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]