I have a number of cells that currently have formulas that output text-fractions ie: "3 / 4" (with space before and after /). I am trying to convert these to a % ie: 75%

I've tried using
* ="="&C9 but this outputs '=3 / 4' as text
* =FIXED(C9,0,TRUE) but this outputs the numeric date quivalent of 40272
* A number of different variants using Indirect() but keep getting #REF! errors

I'm trying to do this without VBA if at all possible.

Any suggestions?

WT