Date Format in Excel

[Anonymous]

Hello everbody I need your help. 

My evaluation in power query works fine. But when I import the data to excel I get a problem with the formatting of a date tpye and I am not quit sure why. As you can see in the picture below power query accept the date as a real date. But after refreshing the conecction in Excel some of the dates are just reccognized as a normal number. It changed the date format. (second screenshot). Is this because there is a "null" value in the date, or why this happens. Furthermore the format of my table changed. As you can see there is no black border around it. 

[Burhan_Jiru]

Hi, 

have a look at this links. 

https://community.powerbi.com/t5/Desktop/How-to-replace-null-values-in-datetime-values/m-p/2667018/h...

https://community.powerbi.com/t5/Desktop/null-handling-in-Date-data-type/td-p/459392

Hope this helps

[Anonymous]

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. 

[Anonymous · Accepted solution]

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 

https://techcommunity.microsoft.com/t5/excel/date-value-changes-to-text-on-refresh-of-power-query-da...