i have done that however some dates are inconsistent1. Select the columns you want to format.
2. Right-click and select “Format Cells”.
3. In the “Number” tab, select “Date” from the “Category” list.
4. Choose the desired date format from the “Type” list and click “OK”.
This will change the format of the selected cells to your desired date format.