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?
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 isk1...@gmail.com wrote:
I have date in this format : *DD.MM.* (with dot) and require it as : *
DD-MMM-* (with hyphen).
Dear Vaibhav
It's not working,. please check the attachment.
Thanks,
Pravin.
-- Forwarded message --
From: VBA VABZ v...@vabs.in
Date: Sat, Jun 22, 2013 at 3:38 PM
Subject: Re: $$Excel-Macros$$ Date format to be changed
To: excel-macros@googlegroups.com excel-macros
: VBA VABZ v...@vabs.in
Date: Sat, Jun 22, 2013 at 3:38 PM
Subject: Re: $$Excel-Macros$$ Date format to be changed
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Select cell, right click, format cell, custom type DD--.
You can use text(cell,DD-MMM-) also.
Thanks
Dear Ahmed,
Thanks it's working fine.. Nice to see you here after long time..
Regards
Pravin Gunjal.
-- Forwarded message --
From: Ahmed Honest ahmedhon...@gmail.com
Date: Sat, Jun 22, 2013 at 5:51 PM
Subject: Re: $$Excel-Macros$$ Date format to be changed
To: excel-macros
here after long time..
Regards
Pravin Gunjal.
-- Forwarded message --
From: Ahmed Honest ahmedhon...@gmail.com
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
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:15 PM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Vaibhav