Date: Sat, Jun 22, 2013 at 5:51 PM
> Subject: Re: $$Excel-Macros$$ Date format to be changed
> To: excel-macros@googlegroups.com
>
>
> Dear Pravin :
>
> Use the below
> =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")
>
>
> On Sat, Jun 22, 2013 at 3:
ere after long time..
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Ahmed Honest
> Date: Sat, Jun 22, 2013 at 5:51 PM
> Subject: Re: $$Excel-Macros$$ Date format to be changed
> To: excel-macros@googlegroups.com
>
>
> Dear Pravi
Dear Ahmed,
Thanks it's working fine.. Nice to see you here after long time..
Regards
Pravin Gunjal.
-- Forwarded message --
From: Ahmed Honest
Date: Sat, Jun 22, 2013 at 5:51 PM
Subject: Re: $$Excel-Macros$$ Date format to be changed
To: excel-macros@googlegroups.com
orwarded message --
> From: VBA VABZ
> Date: Sat, Jun 22, 2013 at 3:38 PM
> Subject: Re: $$Excel-Macros$$ Date format to be changed
> To: "excel-macros@googlegroups.com"
>
>
> Select cell, right click, format cell, custom & type DD--.
>
> You c
Dear Vaibhav
It's not working,. please check the attachment.
Thanks,
Pravin.
-- Forwarded message --
From: VBA VABZ
Date: Sat, Jun 22, 2013 at 3:38 PM
Subject: Re: $$Excel-Macros$$ Date format to be changed
To: "excel-macros@googlegroups.com"
Select cell, righ
Select cell, right click, format cell, custom & type DD--.
You can use text(cell,"DD-MMM-") also.
Thanks
On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal wrote:
> I have date in this format : *DD.MM.* (with dot) and require it as : *
> DD-MMM-* (with hyphen).
> For example :
I have date in this format : *DD.MM.* (with dot) and require it as : *
DD-MMM-* (with hyphen).
For example : I have* 01.04.2013* and want it to be displayed as *
01-APR-2013*
Kindly give me the formula. Thanks
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
