Macro to format date without time

[Howardc1001]

I have dates and time in Col D, that was imported from a csv file


I have tried to write a macro to format the dates (dd/mm/yyyy) without the time using a macro but the time is not removed


I have manually done so (sheet "Manual result") by first using text to columns and then formatting the dates


It would be appreciated if someone can kindly assist me

Please Login or Register  to view this content.

[alansidman]

The quickest way is to use Power Query. Load the table/range to PQ. Change type to Date. Close and Load

Please Login or Register  to view this content.

[Howardc1001]

Thanks Alan. It works perfectly