Help with formatting date

[TonyF57]

I am importing data and the date is in the incorrect format and has a green triangle top left of each date cell.

It gives me the option to ignore error, change date format by converting XX to 19XX or convert XX to 2021

I can resolve it manually by selecting the column and changing format to xx21 but I'd like to do it via a macro.

The macro works up until the point where I select the error dropdown, presumably that is not recordable.

Is there an automatic way of doing this?

Tony

There can be up to 10,000 entries.

I am importing data and the date is in the incorrect format and has a green triangle top left of each date cell.

It gives me the option to ignore error, change date format by converting XX to 19XX or convert XX to 2021

I can resolve it manually by selecting the column and changing format to xx21 but I'd like to do it via a macro.

The macro works up until the point where I select the error dropdown, presumably that is not recordable.

Is there an automatic way of doing this?

Tony

There can be up to 10,000 entries.

Date Format.xlsx
	B
1	30/04/21
2	30/04/21
3	30/04/21
4	30/04/21
5	30/04/21
Sheet1

 

[Fluff]

Thought I had posted a sample of the data in the first post

You did.