how to convert value in date format

[ganeshadeshpande]

my date is in 201203 and i want Mar 2012..........so pl help me

[Pepe Le Mokko]

Question asked many times- Please search the forum

[ganeshadeshpande]

i dont get my required answer through searching pl tell me

[kvsrinivasamurthy]

If A1 contains 201203 use this formula in B1 and format as mmm yyyy using format -number -custom.


=DATE(LEFT(A1,4),RIGHT(A1,2),1)

[:) Sixthsense :)]

Or

In A1 Cell
201203

In B1 Cell

Please Login or Register  to view this content.

[ganeshadeshpande]

thanks for both above reply's & special thanks to sixthsence..............