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.

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

Try the following formula :

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

Regards,

Shamsuddeen

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