Forum Discussion
Solved
Date mistaken for serial number
Im trying to import a csv data set which contains data in the format of dd.mm.yyyy but when importing the file through PowerQuery/BI excel loses the periods and recognizes the resulting decimal numbe...
thank you, I managed to fix it by transforming the decimal numbers into text in the editor.
LukasExcel47 Excel doesn't know that the number 90922 should be interpreted as September 9, 2022. When you then format the cell as a date it will take the 90922nd day, counting from January 1, 1900. And that happens to be December 6 in the year 2148.
You need to fix that when you are importing the CSV-file.
thank you, I managed to fix it by transforming the decimal numbers into text in the editor.