Forum Discussion
Excel date error when the day of month is below 24
I've been importing transaction data from my bank account for years in csv files, but now with Office 2019 some of the dates are wrong. There are two things I find odd. First is that whenever the da...
Solved. I'm blaming myself for not having checked the obvious at the start, but somehow the fact that part of the dates were correct, I made wrong assumptions at the start.
In case someone bumps into a similar thing, check your "Regional format".
Mine was initially "English (Finland)", because I wish to have an English UI, but use local formats.
In the "Time & Language - Region" I had only English formats avalable. So I had to go tothe "Clock and Region - Region/Change date, time or number formats". There you wil find all supported formats.
I am still intrigued to know what caused the error, but glad to have got rid of it.
In case someone bumps into a similar thing, check your "Regional format".
Mine was initially "English (Finland)", because I wish to have an English UI, but use local formats.
In the "Time & Language - Region" I had only English formats avalable. So I had to go tothe "Clock and Region - Region/Change date, time or number formats". There you wil find all supported formats.
I am still intrigued to know what caused the error, but glad to have got rid of it.