Hi Roger

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


"Roger Govier" wrote:

Hi Kaz

Select the ColumnDataText to ColumnsNextNextDateD/M/YFinishWiden the
column

--
Regards
Roger Govier

"Karray" wrote in message
...
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
--
Kaz