Forum Discussion

osabhaois's avatar
osabhaois
Frequent Visitor
5 years ago

Date data changing from custom to general in a single column

I have data from US were the dates format change in a column.   An example is for a date 10/01/2020 03:50 excel is recognising that it is Custom and the text is right indented then just below that...
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

osabhaois 

Try Locale option under Change  Type in Power Query

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn