hi sanjib
i would suggest the below
1. Right Click on Cell and select Format Cells option
2. Custom category in Number tab
3. and type [$-409]dd/mmm/;@ in Type text box
On Mon, Oct 3, 2011 at 1:05 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> But It is not working sir,
But It is not working sir,
I want to put the value as "25/09/2011" and like to display "25/sep/2011"
regards,
sanjib
On Mon, Oct 3, 2011 at 12:58 PM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:
> Hi Sanjib,
>
> The code I had given is vba code it will not change your computer date
>
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.
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/",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
Hi,
Use format function.
ex. MsgBox Format(CDate("03/10/2011"), "dd-mmm-")
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