How to change date format in Excel

Excel users frequently want to change the date format in one or more columns. For example to change between 2 of these formats:

You can do this easily in Easy Data Transform:

  1. Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully fuctional free trial and you don’t have to give us your email or sign up to anything.
  2. Start Easy Data Transform.
  3. Drag the Excel spreadsheet whose columns you wish to change date format of onto Easy Data Transform. A pink input item will be added.
  4. Ensuring the pink input item is selected, click the Date Format button in the left pane.

Excel change date format

A blue transform item is added and selected.

Excel change case

In the right pane:

Excel change case

You can now see that the date format has been changed in the selected columns.

For more details about date formatting options see the Date Format documentation.

When you are happy with the results output the result into a new file.

Easy Data Transform allows you to combine multiple transforms, such as Date Format, to quickly and easily create complex data transformations. For example, you can also combine columns, split columns, merge spreadsheets and dedupe rows, much more easily than you can in Excel.

CSV to HTML converter

Try it free now!

Windows Logo Windows Download

v1.18.0 for Windows 10 / 8 / 7 (36 MB)

Apple Logo Mac Download

v1.18.0 for Mac 11.x to 10.13 (36 MB)

Questions or problems?


Do you have a question?
We would love to help.

This pop-up will not be shown again