Date format in Excel

[Ken]

I have a large spred sheet in which all dates are formated in the US way mm.
dd.yyyy how can I change this to the UK way dd.mm.yyyy, I have experimented
with the normal date formatting but this mixes up days and months.

 

[Ken]

Thanks to both but all a bit too complicated for my skill level. The date I
have has been imported from an address book as a xls file.
All the best
Ken

There is also a nice "Gimmick" by using Text-to-Ccolumns [depending of the
dates format]
One can select the range of sated > Dtata > Text to Columns > Next > Next >
check "date" and choose anither format > "End".
It helped me out a lot...
Micky

I have a large spred sheet in which all dates are formated in the US way mm.
dd.yyyy how can I change this to the UK way dd.mm.yyyy, I have experimented
with the normal date formatting but this mixes up days and months.