You need to truly define what your data is. Do you have text that look like
the US format, or is it a true date simply formatted US style? If the latter,
you can change the formatting of the cells (custom formatting dd.mm.yyyy). If
the former:

=DATE(--RIGHT(A2,4),--LEFT(A2,2),--MID(A2,4,2))

This will convert the text into a true serial date, which you can format
however you want.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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