Excel users frequently want to change the date format in one or more columns. For example to change between 2 of these formats:
31 Jan 2020
Thursday 31 January 2020
You can do this easily in Easy Data Transform:
A blue transform item is added and selected.
In the right pane:
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.
v1.11.2 for Windows 10 / 8 / 7 (50 MB)
v1.11.2 for Mac 11.1 to 10.12 (25 MB)
Questions or problems?