Conversion from text to date

Closed
JM - Dec 8, 2009 at 02:09 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 8, 2009 at 06:06 AM
Hello,

How I can convert this text date to date...

14/02/2011 = 14-Feb-2009 (This should be the result)

Regards,

JM

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 8, 2009 at 06:06 AM
suppose a1 has the entry
14/02/2011

in B1 copy this formula

=LEFT(A1,2)&"-"&TEXT(MID(A1,4,2)*29,"mmmm")&"-"&RIGHT(A1,4)


you will get

14-February-2011

I still am t rying to find out what that number 29 is doing here. any how this works.
0