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.com>wrote: > 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/yyyy", but like to get the >> value as "dd-mmm-yyyy" >> >> (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