Date format AA On Windows 30.09.2006 18:25:01 I have list of Date and time in the column, but I need Date only , not date and time, I was try to use format sell , but it just hiding time but not deleting it. Is any way I can separate date and time and delete time in 1 shot ? LastActionDate 1/2/2006 9:09 1/2/2006 9:22 1/2/2006 9:33 1/2/2006 9:35 1/2/2006 9:35 1/3/2006 10:22 1/5/2006 11:01 ------------------ KSA

Re: Date format "Carim" <carimfam[ at ]yahoo.com> 30.09.2006 18:37:54 Hi, Just type =Int(A1) and copy all th way down ... HTH Cheers Carim

Re: Date format "Bob Phillips" <bob.ngs[ at ]nothere.com> 30.09.2006 19:05:54 You could just format as m/d/yyyy "AA On Windows" <AAOnWindows[ at ]discussions.microsoft.com> wrote in message news:55834A67-9F41-40B1-A368-D20A9E0824F0[ at ]microsoft.com... [Quoted Text] > I have list of Date and time in the column, > but I need Date only , not date and time, > I was try to use format sell , but it just hiding time but not deleting it. > Is any way I can separate date and time and delete time in 1 shot ? > > LastActionDate > 1/2/2006 9:09 > 1/2/2006 9:22 > 1/2/2006 9:33 > 1/2/2006 9:35 > 1/2/2006 9:35 > 1/3/2006 10:22 > 1/5/2006 11:01 > ------------------ > > KSA >

Re: Date format AA On Windows 30.09.2006 20:17:01 Format just hide data , but I need to delete it "Bob Phillips" wrote: [Quoted Text] > You could just format as m/d/yyyy > > "AA On Windows" <AAOnWindows[ at ]discussions.microsoft.com> wrote in message > news:55834A67-9F41-40B1-A368-D20A9E0824F0[ at ]microsoft.com... > > I have list of Date and time in the column, > > but I need Date only , not date and time, > > I was try to use format sell , but it just hiding time but not deleting > it. > > Is any way I can separate date and time and delete time in 1 shot ? > > > > LastActionDate > > 1/2/2006 9:09 > > 1/2/2006 9:22 > > 1/2/2006 9:33 > > 1/2/2006 9:35 > > 1/2/2006 9:35 > > 1/3/2006 10:22 > > 1/5/2006 11:01 > > ------------------ > > > > KSA > > > > >

Re: Date format AA On Windows 30.09.2006 20:20:02 Sorry , did not got it ..? how ? "Carim" wrote: [Quoted Text] > Hi, > > Just type =Int(A1) > and copy all th way down ... > > HTH > Cheers > Carim > >

Re: Date format AA On Windows 30.09.2006 20:23:01 Yes , it is working , but I got 1/2/2006 0:00 , but only need 1/2/2006 "Carim" wrote: [Quoted Text] > Hi, > > Just type =Int(A1) > and copy all th way down ... > > HTH > Cheers > Carim > >