Date format in Excel
 

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.
--
All the best
Ken

Date format in Excel
 

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


"Ken" wrote:

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.
--
All the best
Ken

Date format in Excel
 

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


"מיכאל (מיקי) אבידן" wrote:

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


"Ken" wrote:

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.
--
All the best
Ken