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...
What is the default time format on your computer? It looks like Excel interprets the value 23.3.2021 as 23 hours, 3 minutes and 2021 seconds on your computer. This is equivalent to 23:36:41. Excel stores this time as the number 0,98380787, which is what you see.