Forum Discussion

happy30's avatar
happy30
Copper Contributor
Jul 18, 2022
Solved

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

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 "Da...
  • Riny_van_Eekelen's avatar
    Jul 18, 2022

    happy30 Right-click on any of these 1899 dates

    Replace Values...

    and then>>

    OK

     

Resources