View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chiccada Chiccada is offline
external usenet poster
 
Posts: 18
Default Amending date formats.

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