Forum Discussion
Date Format in Excel
I found a solution for my problem. It has someting to do with the external data properties. For everybody who has the problem: Here is a link to the Microsoft Tech Forum
Hey Burhan,
thanks for your help. But that doesn't really fit to my problem. I checked an other table in power query. This table doens't have any null or blank values and I don't get a convertig error in power query. Only when im refreshing data in excel the date format the newest values is changing from date to numbers.
It seems that I am doing something wrong with the special format of cells. When I am choosing only the coloum B with out the headline date, the format of the cells is date format. With highlighting the headline "Datum" the fomat is chaning to "Standard" (Basic??). Could this maybe the error that I have to change the format when I not only select the colum but the headline as well.
I found a solution for my problem. It has someting to do with the external data properties. For everybody who has the problem: Here is a link to the Microsoft Tech Forum