Josh

When you open a text file in Excel you usually get a Text Import wizard.

This allows you to tell Excel the file is delimited or fixed width and you then go through various other steps.

On one of these steps (the 3rd) you can specify the data format for each column in the file.

One of the format options is Date, which itself has various date format options YMD, MDY, YDM etc

If you have a column with dates you should pick the Date option and pick the format that corresponds
to the data you are importing.

For example you had dates ormatted as DD.MM.YYYY so you would pick DMY.

After you've finished with the wizard you should hopefully have the data formatted as you want.

Since your data had already been imported I used Data>Text to columns... which has much the same
options as the Text Import Wizard.

Hope some of that makes some sort of sense.