Hi, not sure why, I am filtering a column with dates, it only pick up one date, but not showing the rest.
I checked, there is no blank space in the data sheet.
When I re format the data column into numbers, the filter DOES pick everything up. once I format it back to date, the same issue happens
I also tried the same file on another office PC, it works normally.
Not sure what caused the issue. Anyone here experienced the same?
Thanks so much!
Nan
It's a known bug. Please see this recent thread fir a workaround: https://www.excelforum.com/excel-new...-in-my-pc.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Aha! Thanks So much AliGW!!
Hope MS will fix it soon. I'll just work around it. at least I know the issue is not due to my settings etc.
Cheers
Nan
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks