$$Excel-Macros$$ Change date format

Dear experts, I have a data in which date format is Text, I want to change in date format to filter data date and month wise. I have change manually this thing by pressing FR and Enter key. Please provide Macro or function to change the format, the example file is attached herewith. Regards. Ashi

$$Excel-Macros$$ Change date format

Hello Pls change the date format and tell me solution me manually nahi karsakta because 4500 customer same problem Problem Yellow mark find attach file Thanks in advance -- -- Some important links for excel users: 1

$$Excel-Macros$$ CHANGE DATE FORMAT

Dear experts, I want to change date format from 20120121 or 21012012 to 21-Jan-2012, because excel not count as an date format if I replace "-" or "/" character between date,month and year. Is there any function to convert this type of number in proper date format? Because this type of date genera

Re: $$Excel-Macros$$ Change date format

use this formula : CONCATENATE(DAY(C4),"-",MONTH(C4),"-",YEAR(C4))​ On Wed, Jul 16, 2014 at 9:52 AM, Ashish Bhalara wrote: > Dear experts, > > I have a data in which date format is Text, I want to change in date > format to filter data date and month wise. I have change manually this > thing by

Re: $$Excel-Macros$$ Change date format

Select one column at a time containing data, then goto Data >> Text to column (or just press Alt + D then E). Select Fixed width & press Next 2 time, now select Date & existing date format viz. DMY for Date-Month-Year and press finish. Cheers!! On Wed, Jul 16, 2014 at 12:22 PM, Ashish Bhalara

Re: $$Excel-Macros$$ Change date format

Oh Thanks to both of you, its very easy...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Wed, Jul 16, 2014 at 12:29 PM, Amresh Maurya wrote: > see the attachment > > > On Wed, Jul 16, 2014

Re: $$Excel-Macros$$ Change date format

Just run the macro or press ctrl+g,it will do the needful you required. Regards, C.G.kumar On Mon, Nov 16, 2009 at 1:23 PM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > Hello > Pls change the date format and tell me solution > me manually nahi karsakta because 4500 customer

RE: $$Excel-Macros$$ Change Date Format

Hi, If you double click in the first cell, then press Enter, the cell is displayed as you require. You can either do this in each cell manually, or you can write a macro to do it for you. Regards - Dave. Date: Tue, 24 Nov 2009 12:58:32 +0530 Subject: $$Excel-Macros$$ Change Date Format From

Re: $$Excel-Macros$$ Change Date Format

ell is > displayed as you require. > You can either do this in each cell manually, or you can write a macro to > do it for you. > Regards - Dave. > > -- > Date: Tue, 24 Nov 2009 12:58:32 +0530 > Subject: $$Excel-Macros$$ Change Date Format > From: nand

Re: $$Excel-Macros$$ Change Date Format

hi, do as following Select the column in which date is there, press ALT+D then E, convert text to column will appear press next then next once again, select date option then finish. thanks vir 2009/11/24 Nandkumar kakvipure > Hello, > Please Help me > my system generate date format 14/10/09

Re: $$Excel-Macros$$ Change Date Format

Hello Pals, I am very much grateful for the solution you all had provided for my problem. Thanks Nandkumar On Tue, Nov 24, 2009 at 12:58 PM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > Hello, > Please Help me > my system generate date format 14/10/09 this type but i need 14 Oct

Re: $$Excel-Macros$$ Change Date Format

Hello Please help me in giving the address of a good Excel and VBA tutorial around Ghatkopar, Mumbai. Thanks Nandkumar On Tue, Nov 24, 2009 at 12:58 PM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > Hello, > Please Help me > my system generate date format 14/10/09 this type but

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

Hi Ashish, use this formula (if you date format is same 20120121 ) *=DATEVALUE(CONCATENATE(LEFT(B2,4),"-",MID(B2,5,2),"-",RIGHT(B2,2)))* On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara wrote: > Dear experts, > > I want to change date format from 20120121 or 21012012 to 21-Jan-2012, > because ex

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

or try this one.. for any format =TEXT(B2,"-00-00")+0 On Sat, Jan 21, 2012 at 10:14 AM, xlstime wrote: > Hi Ashish, > > use this formula (if you date format is same 20120121 ) > > *=DATEVALUE(CONCATENATE(LEFT(B2,4),"-",MID(B2,5,2),"-",RIGHT(B2,2)))* > > > On Sat, Jan 21, 2012 at 9:50 AM, As

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

try this =TEXT(TEXT(B3,"-00-00"),"DD-MM-") chandru On Sat, Jan 21, 2012 at 10:16 AM, xlstime wrote: > or try this one.. for any format > > =TEXT(B2,"-00-00")+0 > > > On Sat, Jan 21, 2012 at 10:14 AM, xlstime wrote: > >> Hi Ashish, >> >> use this formula (if you date format is sa

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

Thanks a lot for formula, could you please explain the means of "+0" in the end of formula? Thanks from Ashish. On Sat, Jan 21, 2012 at 10:29 AM, chandra sekaran wrote: > > try this > > =TEXT(TEXT(B3,"-00-00"),"DD-MM-") > > chandru > > > > On Sat, Jan 21, 2012 at 10:16 AM, xlstime wrote

Fwd: $$Excel-Macros$$ CHANGE DATE FORMAT

for convert to number format ... u also use ''--'' befor formula like =--TEXT(B2,"-00-00") On Sat, Jan 21, 2012 at 11:40 AM, Ashish Bhalara wrote: > Thanks a lot for formula, could you please explain the means of "+0" in > the end of formula? > > Thanks from Ashish. > > > On Sat, Jan 21, 2012

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

You can also use *1 befor formula like =-TEXT(B2,"-00-00")*1 On Sat, Jan 21, 2012 at 11:46 AM, xlstime wrote: > for convert to number format ... u also use ''--'' befor formula like > =--TEXT(B2,"-00-00") > > > On Sat, Jan 21, 2012 at 11:40 AM, Ashish Bhalara < > ashishbhalar...@gmail.co