RE: $$Excel-Macros$$ Date conversion to other format

2013-06-16 Thread Dhartikumar Sahu
Please find attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 14 June 2013 12:10 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date conversion to other format Hi, I want to convert the date =Today() to

Fwd: $$Excel-Macros$$ Date conversion to other format

2013-06-13 Thread Pravin Gunjal
Fantastic... Thanks Vaibhav & Noorain. Regards Pravin. -- Forwarded message -- From: VBA VABZ Date: Fri, Jun 14, 2013 at 12:15 PM Subject: Re: $$Excel-Macros$$ Date conversion to other format To: excel-macros@googlegroups.com refer.. On Fri, Jun 14, 2013 at 12:10 PM, Pr

Re: $$Excel-Macros$$ Date conversion to other format

2013-06-13 Thread VBA VABZ
refer.. On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal wrote: > Hi, > > I want to convert the date =Today() to this format : DD.MM. > > Formula =Today() 6/14/2013 In next cell, it should display as : > 14.06.2013 > Sample file is attached. Thanks. > > Regards > Pravin Gunnjal > > -- >

Re: $$Excel-Macros$$ Date conversion to other format

2013-06-13 Thread NOORAIN ANSARI
Dear Pravin try it =TEXT(TODAY(),"dd.mm.") or select cell and press ctrl+1 and type in custom format dd.mm. On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal wrote: > Hi, > > I want to convert the date =Today() to this format : DD.MM. > > Formula =Today() 6/14/2013 In next cel

$$Excel-Macros$$ Date conversion to other format

2013-06-13 Thread Pravin Gunjal
Hi, I want to convert the date =Today() to this format : DD.MM. Formula =Today() 6/14/2013 In next cell, it should display as : 14.06.2013 Sample file is attached. Thanks. Regards Pravin Gunnjal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT