Formula to convert to date format

[Ecel Dumbo]

Hello People,


Could you please help me with a formula to convert the below data in to required date format


Data Required date format

10.201 Oct-10

10.2011 Oct-11

10.2012 Oct-12


if u notice, for 10.2010, in excel it is appearing as 10.201 , missing the zero at the end.


Thanks

 

[NARAYANK991]

Hi ,


Try this :


=DATE((A1-INT(A1))*10000,INT(A1),1)


where A1 contains your numeric value.


Format the above formula cell as Custom mmm-yy


Narayan

 

[Ecel Dumbo]

This is excellent. Thanks Narayan