Convert the fraction to Month and Year
Closed
Maha
-
Oct 7, 2011 at 01:23 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 7, 2011 at 06:09 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 7, 2011 at 06:09 AM
Related:
- How to convert fraction into years
- Youtube to mp3con converter - Download - Music downloads
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
- Convert number to words in excel - Guide
- Convert dts to ac3 mkvtoolnix - Guide
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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
