yes, the date is 02 June. how do i go aboutThe bad news is that your dates are already in the (crazy) US format! It just happens that the date is 6-Feb which may well be wrong; are you expecting the 6-Jun? The problem arises where dates are read into Excel as text strings. If the machine localisation does not correspond to the convention used for the text version, a mess ensues. Where Excel has recognised a date, it can be corrected using the formula
Converting the text (23-Jun will fail to convert) is more of an issue.
I would recommend re-reading the original data source using Power Query and convert to DateTime using the localisation appropriate to the data.