SOLVED

Replacing Nulls/30/12/1899 dates in Excel Power Query

New Contributor

Hi Team,

 

I have been doing power query for data cleaning. I have seen that one of the calendar column (Date/Time) is in "Text" data type. When we try to change the data type in power query as "Date/Time" Data type, all the null rows in that column brings date like 30/12/1899. Can anyone advise on this how to get rid of this dates or replace those dates or nulls to something else we want or may be we can keep as blank?

 

Thanks!

2 Replies
best response confirmed by happy30 (New Contributor)
Solution

@happy30 Right-click on any of these 1899 dates

Riny_van_Eekelen_0-1658118641993.png

Replace Values...

and then>>

Riny_van_Eekelen_2-1658118704035.png

OK

 

This worked! Thank you