format date

[Karray]

I am working on a spreadsheet that someone else created. The dates are set
as e.g. 13.03.09 - I want this to read 13/03/09 I have tried formatting cells
to date dd/mm/yy and clicking ok but it doesn't alter anything. Apart from
going in and altering each cell individually nothing else seems to work.
Please help

 

[Gordon]

I am working on a spreadsheet that someone else created. The dates are set
as e.g. 13.03.09 - I want this to read 13/03/09 I have tried formatting cells
to date dd/mm/yy and clicking ok but it doesn't alter anything. Apart from
going in and altering each cell individually nothing else seems to work.
Please help

You could try a Find and replace...Find **.**.** replace with **/**/**

 

[Roger Govier]

Hi Kaz

Select the Column>Data>Text to Columns>Next>Next>Date>D/M/Y>Finish>Widen the
column

 

[Karray]

Hi Gordon

Thanks for the reply. It didn't actually work as my dates are all
different. Thanks for trying anyway.

 

[Karray]

Hi Roger

Worked a treat thanks very much. Saved me alot of time and work.