Convert the fraction to Month and Year [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,


I need to convert 05/10 to Month and then Year. i.e.,

for Example it should come as May 2010.

Please give an idea to get the above output in the Excel 2003.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
suppose 5/10 is in A1

in empty cell copy this formula

=(LEFT(A1,SEARCH("/",A1)-1)&"/1/"&RIGHT(A1,LEN(A1)-SEARCH("/",A1)))+0

CUSTOM format this cell as
mmm yyyy
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3859 users have said thank you to us this month