How do you know which is which? With 26/6/07 or 6/26/07 it's obvious, but
how do you know what 4/6/07 is intended to be? Can you perhaps rely on all
the ones which are actually numbers [ISNUMBER()] being UK style, and all
those which are text cells [ISTEXT()] being US (or v.v.)?
--
David Biddulph

"Chiccada" wrote in message
...
Hi all,

I have a column in a spreadsheet which shows dates. These dates are mixed
between U.S. style and UK style. What the quickes way to switch them all
over
to UK style?

I have tried mass formatting the cells but this does not work and it will
take me forever to adjust them individually.

Many thanks in advance,

Rik