convert fraction to text

As per attached example i have column G with a list of fractions (formatted as "??/???" and what i want to do is convert this list (from G2 to the last cell) from fractions to text.

I have done this manually by adding a formula in H2

=TEXT(G2,"??/???")

then doing an autofill on this fomula to the end of the list in column G. Then copying from H2 to bottom of the list in that column and pasting 'values only' back over G2 to the end of the list and then deleting the temporary column H. I can't seem to get it to work in vba code

I'd appreciate your help.

Cheers.