Dear CK, try it...
*for dd/mm/yy format* *Function dd_mm_yy(s As Range) dd_mm_yy = VBA.Format(s, "dd/mm/yy") End Function * *for dd mm yy format Function with_Space(s As Range) with_Space = VBA.Format(s, "dd" & " " & "mm" & " " & "yy") End Function * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> On Fri, Sep 23, 2011 at 5:15 PM, ck naidu <sai21...@gmail.com> wrote: > Hi Macros,,,,,,,,,,,,,,,,, > > How could we fix the date format to "DD/MM/YY". So, If we enter other > format it should convert to "DD/MM/YY" > > Ex: I want like DD MM YY only > > 24/11/1985 --- This is correct format > > 11/24/1985 ---- this should convert into 24/11/1985 automatical how it is > possible.... pls help me....... > > > > Thanks > Sai > +91 96669 31919 > > On 23 September 2011 05:26, <excel-macros@googlegroups.com> wrote: > >> Today's Topic Summary >> >> Group: http://groups.google.com/group/excel-macros/topics >> >> - [No >> Subject]<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_group_thread_0>[2 >> Updates] >> - Convert txt file to >> xls<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_group_thread_1>[4 >> Updates] >> - Export >> Data<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_group_thread_2>[1 >> Update] >> - Increasing rows in Excel >> 2010<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_group_thread_3>[2 >> Updates] >> - I need your help - >> Urgent<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_group_thread_4>[2 >> Updates] >> - Required Latest No. of Drawing - >> Help<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_group_thread_5>[1 >> Update] >> >> Topic: [No >> Subject]<http://groups.google.com/group/excel-macros/t/6026fe9fd49d7639> >> >> naanu v <naanu2...@gmail.com> Sep 22 09:20PM +0530 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> kindly provide macro for Index formula >> >> >> >> >> XLS S <xlst...@gmail.com> Sep 23 05:01AM +0530 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> please specify requirement and condition >> >> >> -- >> ......................... >> >> >> >> Topic: Convert txt file to >> xls<http://groups.google.com/group/excel-macros/t/ed925791abadc651> >> >> Sandeep Pathak <sandeeppathak...@gmail.com> Sep 22 03:50AM -0700 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> Dear Team, >> >> Is there any way to convert text file to excel, except change of >> extension name... >> >> Please advise... >> >> Regards, >> Sandeep >> >> >> >> >> Ram Naresh Verma <rnverma2...@gmail.com> Sep 22 11:05PM +0530 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> sandeep, >> >> go to command prompt >> go to the directry where the txt file exist >> use command ren abc.txt cld.xls >> it will definately work.... >> i had tried the same... >> >> On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak >> >> -- >> Regards, >> Ram Naresh >> >> >> >> >> Paul Schreiner <schreiner_p...@att.net> Sep 22 10:56AM -0700 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> Keep in mind that an Excel file is more than a file extension! >> >> What you're asking is best answered if we know your INTENT. >> >> The only way (that I know of) to make a text file into an Excel file >> is to open >> it in Excel and allow Excel to load the data into an Excel format and >> then save >> the file. >> >> changing the file extension doesn't change the FILE, what it does is >> tells Windows to use Excel when opening the file. >> You could do the same thing by changing the Windows File associations >> to use >> Excel.exe >> to open any file with a .txt extension. >> But when Excel opens the file, it will STILL need to use some >> mechanism to >> "import" the data and display it in an Excel format. >> >> >> So your question: >> Is there any way to convert text file to excel, except change of >> extension >> name... >> >> does not make sense from the standpoint that changing the extension >> does NOT >> convert the text file to Excel. >> >> So, either I'm misunderstanding what you mean by "convert text file", >> or at the >> least, we need >> to understand what it is you're trying to accomplish... >> >> >> >> Paul >> ----------------------------------------- >> “Do all the good you can, >> By all the means you can, >> In all the ways you can, >> In all the places you can, >> At all the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> ----------------------------------------- >> >> >> >> >> ________________________________ >> From: Ram Naresh Verma <rnverma2...@gmail.com> >> To: excel-macros@googlegroups.com >> Sent: Thu, September 22, 2011 1:35:36 PM >> Subject: Re: $$Excel-Macros$$ Convert txt file to xls >> >> >> sandeep, >> >> go to command prompt >> go to the directry where the txt file exist >> use command ren abc.txt cld.xls >> it will definately work.... >> i had tried the same... >> >> >> On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak < >> sandeeppathak...@gmail.com> >> wrote: >> >> Dear Team, >> >> ><><><><><><><><><><><><><><><><><><><><><><> >> >Like our page on facebook , Just follow below link >> >http://www.facebook.com/discussexcel >> >> -- >> Regards, >> Ram Naresh >> -- >> >> >> ---------------------------------------------------------------------------------- >> >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> >> >> >> XLS S <xlst...@gmail.com> Sep 23 04:56AM +0530 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> Use export and import function or right click on ur txt file and open >> with >> excel >> >> On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak >> >> -- >> ......................... >> >> >> >> Topic: Export >> Data<http://groups.google.com/group/excel-macros/t/aa8372b8fa1d73b5> >> >> "dguillett1" <dguille...@gmail.com> Sep 22 08:55AM -0500 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> I would copy the sheet to the desktop and save as and close >> >> Sub CopyDetailsToDesktopSAS() >> mydesktop = Environ("userprofile") & _ >> Application.PathSeparator & "Desktop" & _ >> Application.PathSeparator >> >> mypath = ActiveWorkbook.Path >> >> With Sheets("Details") >> .Copy >> newname = .Name & " - " & Format(Date, "mm-dd-yy") >> >> With ActiveWorkbook >> .SaveAs Filename:=mydesktop & newname & ".xls" >> .Close >> End With >> >> End With >> ChDir mypath >> End Sub >> From: Mr Excellent >> Sent: Thursday, September 22, 2011 12:29 AM >> To: excel-macros@googlegroups.com >> Subject: $$Excel-Macros$$ Export Data >> >> Hi Group >> >> I have a spread sheet which has 3 TABS and the last tab is saved with >> the required information and i need a VBA code for exporting only the TAB >> named as "Details" to be exported on my desktop with xls format and file >> which has to be saved should be named as "Details - Present Date( >> DD-MM-YYYY).xls" >> >> Could anyone help me on this. >> >> Thanks >> Prasad >> -- >> >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> >> >> Topic: Increasing rows in Excel >> 2010<http://groups.google.com/group/excel-macros/t/6a05e09f6cbf5b02> >> >> NOORAIN ANSARI <noorain.ans...@gmail.com> Sep 22 04:49PM +0530 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> Thanks Kanwaljit.. >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*< >> http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/* < >> http://noorain-ansari.blogspot.com/> >> >> >> >> >> Chandra Shekar <chandrashekarb....@gmail.com> Sep 22 03:20PM +0200 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> Thank a lot Noorain :-) >> >> >> >> >> Topic: I need your help - >> Urgent<http://groups.google.com/group/excel-macros/t/ff961dc3b60676c9> >> >> Amresh Maurya <amreshkushw...@gmail.com> Sep 22 04:05AM -0700 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> Thank you so much.. >> >> perfect.. >> >> Regards >> Amresh >> >> >> >> >> >> Amresh Maurya <amreshkushw...@gmail.com> Sep 22 04:12AM -0700 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> Hi Noorain, >> >> >> I Read your Excel poem on your blog : * >> http://noorain-ansari.blogspot.com/.* >> >> Awesome... Keep on.. >> >> >> Regards >> Amresh >> >> >> >> >> Topic: Required Latest No. of Drawing - >> Help<http://groups.google.com/group/excel-macros/t/22fe3f2f44e253bb> >> >> "dguillett1" <dguille...@gmail.com> Sep 22 07:34AM -0500 >> ^<https://mail.google.com/mail/html/compose/static_files/blank_quirks.html#132961b554450ab8_132939250e1a5959_digest_top> >> >> Can you provide an AFTER example >> >> -----Original Message----- >> From: Rohan Young >> Sent: Thursday, September 22, 2011 2:30 AM >> To: excel-macros@googlegroups.com >> Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help >> >> ---------- Forwarded message ---------- >> From: Rohan Young <rohan.j...@gmail.com> >> Date: Tue, Jul 26, 2011 at 2:22 PM >> Subject: Required Latest No. of Drawing - Help >> To: excel-macros@googlegroups.com >> >> >> Dear Experts >> >> I want to make a list drawing in which i required only latest revision >> of drawings it can be R3, R5, i need only latest version rest of >> previous i do not required in that list please help me out with any >> formula or vba code (see attachment) >> >> Thanks & Regds, >> >> -- >> >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > ThanX, > Chudheer Kumar > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
