Hi there, I am using =IF(X14=””,””,(LEFT(X14,1)&”/”&RIGHT(X14,1))) for below table

10.6+ | 1/+ | 8.8 | 8/8 |

7.2 | 7/2 | 7.1 | 7/1 |

6.4 | 6/4 | 6.6 | 6/6 |

7.2 | 7/2 | 7.5 | 7/5 |

7.2 | 7/2 | 6.4 | 6/4 |

but apparntly it is not working for 10.6+ , it should be 10/6 . Is there a formula to resolve this issue pls ??

By: Ash

=LEFT(A1,FIND(“.”,A1)-1)&”/”&MID(A1,FIND(“.”,A1)+1,10)

10.6+ in A cell will be converted to 10/6+

if you don’t need +

=LEFT(A1,FIND(“.”,A1)-1)&”/”&SUBSTITUTE(MID(A1,FIND(“.”,A1)+1,10),”+”,””)

10.6+ will be converted to 10/6

this would work for any number with more digits

like 125500.65558+++ to 125000/65558