Sep 09 2022 04:49 AM
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?
Sep 09 2022 05:36 AM - edited Sep 09 2022 05:36 AM
@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.
Sep 09 2022 06:35 AM - edited Sep 09 2022 06:37 AM
Solution
thank you, I managed to fix it by transforming the decimal numbers into text in the editor.
Sep 09 2022 06:35 AM - edited Sep 09 2022 06:37 AM
Solution
thank you, I managed to fix it by transforming the decimal numbers into text in the editor.