Hi
Mark the range of cells with the data to be converted.
DataText to ColumnsNextNextDateD/M/YFinish
Format the date column as required.

--
Regards

Roger Govier



hme wrote:
Hi Excelpower

Thanks for prompt reply.
The data is in general format and it is requested to change to date
format.
for example:"ABCDEFGH" should change to "GH/EF/ABCD" in date format.

thk,

hmeHi