Dates converted into text
in [Programming]
|
From: rjagathe on 6 Mar 2010 02:35 On Mar 4, 10:50 pm, Gord Dibben <gorddibbATshawDOTca> wrote: > Try Data>Text to Columns>Next>Next>Column Data Format DMY > > Gord Dibben MS Excel MVP > > On Thu, 4 Mar 2010 08:43:08 -0800 (PST), rjagathe <rjaga...(a)gmail.com> > 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. Hi when I tried this, for whatever year I gave, it returns year as 1905 only. with regards rjagathe
From: Gord Dibben on 6 Mar 2010 16:30
Typo...............YMD should have been the format. Gord On Fri, 5 Mar 2010 23:35:33 -0800 (PST), rjagathe <rjagathe(a)gmail.com> wrote: >On Mar 4, 10:50�pm, Gord Dibben <gorddibbATshawDOTca> wrote: >> Try Data>Text to Columns>Next>Next>Column Data Format DMY >> >> Gord Dibben �MS Excel MVP >> >> On Thu, 4 Mar 2010 08:43:08 -0800 (PST), rjagathe <rjaga...(a)gmail.com> >> 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. > >Hi >when I tried this, for whatever year I gave, it returns year as 1905 >only. > >with regards >rjagathe |