Try DataText to ColumnsNextNextColumn Data Format DMY


Gord Dibben MS Excel MVP

On Thu, 4 Mar 2010 08:43:08 -0800 (PST), rjagathe
wrote:

I receive Excel data from my branch offices.the data should contain
date coloumns.But some cells contain dates in "<year<month.<date"
format i.e.,21/02/2010 in dd/mm/yyyy format is displayed as
20100221.Why it is happening?How to convert them into dd/mm/yyyy
format?
I tried to record and run a macro to insert "/" between year and month
and between month and date,then clicking "Enter" button...But,it
displays same date in all the cells in which I run the macro.