Epinn,

When you enter the 1/2, 1/5 etc. you will see that in the formula bar it
shows 0.5, 0.2 etc. which is what is the value that is really held in the
cell not what you see, (which of course is only displayed differently to
show it how you requested. So when you reformat it to Text it is
reformatting the real value so it is not actually changing anything so does
not require a formula.

As to your text formula problem, I get 11/16 as expected.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Epinn" wrote in message
...
....... 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