thank you for your quick responce Swapnil Palande . But i want to say is there any option in excel to put the date value like "dd/mm/yyyy",without changing my computer date format.
Thanking you Sanjib On Mon, Oct 3, 2011 at 11:43 AM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > Hi, > > Use format function. > > ex. MsgBox Format(CDate("03/10/2011"), "dd-mmm-yyyy") > Regards, > > Swapnil. > On Mon, Oct 3, 2011 at 11:33 AM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear Friends, >> >> would u please help me about the below mentioned problem in VBA EXCEL >> >> I like to put the date value in excel as "dd/mm/yyyy". But like to get >> the output >> as "dd-mmm-yyyy" >> >> please help and oblige >> >> Thank you in advance >> >> Ragards, >> >> 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 > -- ---------------------------------------------------------------------------------- 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