Convert a data type
Let’s convert a data type. The Order Date field is formatted as month, day, year, hours and minutes. If you just want the Date, you can convert it.
-
Select the Date column, select Home > Transform > Data Type, and then select the Date option. You can convert other numeric types, such as percentage or currency.
Note If you get a notification that data type transformations already exist, you can ignore it, since you're overwriting the date transformation that Power Query thought you wanted when you loaded the data. -
To return the transformed data to the Excel worksheet, Select Home > Close & Load.