Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

Help ? Convert date

Posted by Marc on December 09, 2001 2:29 AM

Anybody, Is there a way to convert (example 06-nov-01 into 6-10)with a formula. If I take 06-nov-01 en try to change the format of the cell it does'nt work, probebly because of date + the year. I've got hundreds
of dates I need to convert to a format like 6-10.

Please help, mayby with a Macro.

Re: Help ? Convert date

Posted by Shamsuddeen. P.K on December 09, 2001 9:29 AM

Try the following formula :

=TEXT(C6,"dd")&"-"&TEXT(C6,"mm")

Regards,

Shamsuddeen

Re: Help ? Convert date

Posted by Jack on December 09, 2001 9:34 AM

Shamsuddeen, good formula but needs to be mmm
=TEXT(D11,"dd")&"-"&TEXT(D11,"mmm")

Well done

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.