Convert the fraction to Month and Year

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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 2942 users have said thank you to us this month