=TEXT(LEFT(C6,SEARCH("/",C6)-1)/RIGHT(SUBSTITUTE(C6, " IN", ""),LEN(SUBSTITUTE(C6, " IN", ""))-SEARCH("/",SUBSTITUTE(C6, " IN", ""))), ".0###") & " IN"
i want this formaul convert fraction to decimal like ex(1/2) .5 i want it show like (0.5)
2/4
=TEXT(LEFT(C6,SEARCH("/",C6)-1)/RIGHT(SUBSTITUTE(C6, " IN", ""),LEN(SUBSTITUTE(C6, " IN", ""))-SEARCH("/",SUBSTITUTE(C6, " IN", ""))), ".0###") & " IN"
i want this formaul convert fraction to decimal like ex(1/2) .5 i want it show like (0.5)
2/4
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks