I have an issue with dates in Excel, which is driving me loopy.
We have a database which records all our projects, that has been in use for a long time. We have various queries which are created from the database and exported to Excel using macros and these have been working fine until now.
I've been issued with a new laptop as my old one was dead, and now when I run the queries, if I try to sort by date then the result is wrong and looks like it's in US format (mm/dd) except it doesn't error when it hits 13. So I suspect it's actually being output as text rather than a date.
Nobody else is affected. They can sort as they always have, so it has to be something on my new setup, but i don't know what. I've gone through user settings for date, region, etc and they're all ok. Nothing has changed with the database or any of our queries/macros, and if somebody else runs a report and forwards it to me, I can sort it as normal.
We had something similar a couple of years back when somebody had a new PC, but can't for the life of me remember how we solved it.
Thanks for any help