Support

Sign in

Sign in with Microsoft

Sign in or create an account.

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Convert a data type

Applies To

Excel for Microsoft 365 Microsoft 365 for business

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.

In Power Query, select the Date column, then depending on your version, select one of the following options:

Home > Transform
Transform

Select 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.