Convert the fraction to Month and Year
Closed
Maha
-
Oct 7, 2011 at 01:23 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 7, 2011 at 06:09 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 7, 2011 at 06:09 AM
Related:
- Convert fraction to months
- Convert m3u to mp3 - Guide
- Convert dts to ac3 mkvtoolnix - Guide
- How to convert free fire id facebook to google - Guide
- Convert picture to shape powerpoint - Guide
- Netflix free trial 3 months - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 7, 2011 at 06:09 AM
Oct 7, 2011 at 06:09 AM
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
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
