Re: $$Excel-Macros$$ Fwd: date format help
Hello Dear, I think It's work use this key Shift+Ctrl+3. -- -- 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
Re: $$Excel-Macros$$ Fwd: date format help
Dear Sanjib, Please use below code as per your requirement. *Function Date_Format(d As Date) Date_Format = Format(d, dd-mmm-) End Function * On Fri, Sep 30, 2011 at 1:19 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear All Please go through the mail and help me. Ragards, sanjib -- Forwarded message -- From: Sanjib Chatterjee chatterjee.kolk...@gmail.com Date: Fri, Sep 30, 2011 at 12:15 PM Subject: date format help To: excel-macros excel-macros@googlegroups.com Dear All members, please help me regarding date format in Excel. I want to put the value in excel as dd/mm/, but like to get the value as dd-mmm- (i.e. 30/09/2011 should display 30-sep-2011, 01/12/2011 should display 01-dec-2011) Thank you in advance Regards, Sanjib -- -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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
Re: $$Excel-Macros$$ Fwd: date format help
I seem to be missing something... PROVIDED that your Windows Date format is dd/mm/ when you enter a string in this format, Excel recognizes it as a date. As such, you can: Right-click the cell(s) select Format Cells on the Number tab, select Date. There SHOULD be a format at the bottom called 14-Mar-2001 if not, then select Custom (instead of Date) and enter dd-mmm- now... IF Excel is not recognizing your string of characters as an actual date, then this method will not work, and you must either convert it to a date, or use string manipulations. 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: Sanjib Chatterjee chatterjee.kolk...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent: Fri, September 30, 2011 3:49:05 AM Subject: $$Excel-Macros$$ Fwd: date format help Dear All Please go through the mail and help me. Ragards, sanjib -- Forwarded message -- From: Sanjib Chatterjee chatterjee.kolk...@gmail.com Date: Fri, Sep 30, 2011 at 12:15 PM Subject: date format help To: excel-macros excel-macros@googlegroups.com Dear All members, please help me regarding date format in Excel. I want to put the value in excel as dd/mm/, but like to get the value as dd-mmm- (i.e. 30/09/2011 should display 30-sep-2011, 01/12/2011 should display 01-dec-2011) Thank you in advance Regards, Sanjib -- -- 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
Re: $$Excel-Macros$$ Fwd: date format help
SIMPLE WAY SELECT THAT CELLS GO TO FORMAT CELLS THEN CLICK ON NUMBER--CUSTOM--- TYPE THE DD-MMM-YY IN THE TYPE FIELD On Fri, Sep 30, 2011 at 2:28 PM, Amresh Maurya amreshkushw...@gmail.comwrote: Hi PFA Solution. On Fri, Sep 30, 2011 at 12:49 AM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear All Please go through the mail and help me. Ragards, sanjib -- Forwarded message -- From: Sanjib Chatterjee chatterjee.kolk...@gmail.com Date: Fri, Sep 30, 2011 at 12:15 PM Subject: date format help To: excel-macros excel-macros@googlegroups.com Dear All members, please help me regarding date format in Excel. I want to put the value in excel as dd/mm/, but like to get the value as dd-mmm- (i.e. 30/09/2011 should display 30-sep-2011, 01/12/2011 should display 01-dec-2011) Thank you in advance Regards, Sanjib -- -- 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 -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- -- 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
Re: $$Excel-Macros$$ Fwd: date format help
You can select the date format as dd-mmm- format cell option. On 30 Sep 2011 13:19, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear All Please go through the mail and help me. Ragards, sanjib -- Forwarded message -- From: Sanjib Chatterjee chatterjee.kolk...@gmail.com Date: Fri, Sep 30, 2011 at 12:15 PM Subject: date format help To: excel-macros excel-macros@googlegroups.com Dear All members, please help me regarding date format in Excel. I want to put the value in excel as dd/mm/, but like to get the value as dd-mmm- (i.e. 30/09/2011 should display 30-sep-2011, 01/12/2011 should display 01-dec-2011) Thank you in advance Regards, Sanjib -- -- 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