Currently exporting date into Excel in this format: Jun 22, 2019, 09:38 AM
Update: the dates appear in each cell within the column (1 date per cell in a column needs to be converted into another column of short dates)
Want to convert to: 22/06/2019
Have tried long way of Text to Columns and replacing "Jun" and other months to "6" so I can use DATE function to put it together to get result - but would like a quicker method with having to insert all the columns to unpack the date just to put it back together.
Thanks
Update: the dates appear in each cell within the column (1 date per cell in a column needs to be converted into another column of short dates)
Want to convert to: 22/06/2019
Have tried long way of Text to Columns and replacing "Jun" and other months to "6" so I can use DATE function to put it together to get result - but would like a quicker method with having to insert all the columns to unpack the date just to put it back together.
Thanks

Last edited: