Hi Sanjib,
The code I had given is vba code it will not change your computer date
format.
If you want to change date format for particular cell without using code
then you can do that using following method
1. Right Click on Cell and select Format Cells option
2. Custom category in Number tab
3. and type "dd/mm/yyyy" in Type text box
Regards,
Swapnil
On Mon, Oct 3, 2011 at 12:28 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> 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
>
--
----------------------------------------------------------------------------------
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
