....... and still shows the fraction instead of decimals?

I have formatted a range of cells to fraction. Then I key in the following values:-

1/2
1/5
1/4
1/3
2/7
9/16 etc. etc.

Then I format the cells to text and the fractions are converted to decimals. How can I have both text format and the fractions displayed as above without writing a formula?

I tried custom format, paste specialvalues etc. and had no luck.

I am also having trouble with a formula which works most of the time but not *all the time*.

e.g. A7 formatted to fraction8/16 then I key in 11/16.

The formula =TEXT(A7,"##/##") returns 9/13 instead of 11/16.

If I have to use a formula, is there a way to write one that will take care of all types of fractions shown in the drop-down list e.g. 1/4, 21/25, 8/16, 1/2, 3/10 etc. etc.

Appreciate guidance.

Epinn