Forum Discussion
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 number in the serial number format. How do I return these numbers back to their correct dates?
thank you, I managed to fix it by transforming the decimal numbers into text in the editor.
2 Replies
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.
