SOLVED

Date mistaken for serial number

Copper Contributor

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?

 

LukasExcel47_0-1662724063080.png

 

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.

best response confirmed by LukasExcel47 (Copper Contributor)
Solution

@Riny_van_Eekelen 

 

thank you, I managed to fix it by transforming the decimal numbers into text in the editor.

1 best response

Accepted Solutions
best response confirmed by LukasExcel47 (Copper Contributor)
Solution

@Riny_van_Eekelen 

 

thank you, I managed to fix it by transforming the decimal numbers into text in the editor.

View solution in original post