Turn a fraction around, then show it as a decimal

Hello.
Is it possible to enter a fraction into A1, say 5/8, then automatically reverse the numerator and denominator so that the fraction shows as 8/5 in B1 and then convert it into a decimal, so the final result reads 1.6 in C1?

Thank you.

Originally Posted by hemesh

may be below
In A1 type =5/8 and in B1 copy paste below

=INDEX(TRIM(MID(SUBSTITUTE(TEXT(A1,"???/???"),"/",REPT(" ",50)),{1,30},50)),,2)/INDEX(TRIM(MID(SUBSTITUTE(TEXT(A1,"???/???"),"/",REPT(" ",50)),{1,30},50)),,1)

To see the reverse numerator and denominator set the cell formatting to fraction

That works, but the fractions will be copied and pasted from another location and I don't want to have to enter the equal sign to each one. I've spent weeks reversing the fraction manually and then converting it into a decimal. I was hoping to just copy and paste and then have the rest performed automatically.
Thank you for your help.

Originally Posted by MrShorty

Is the fraction entered as a number or as a text string? If the fraction is a real number (0.625 formatted as #/#), then it should be as simple as =1/B1 formatted as general or 0.0 or whatever number format you want.

That's works exactly as I want it to! (easy when you know how)
I'll play around with both solutions before deciding which one to use. Thank you both so much for your help.