Have you thought to set it up within Autocorrect Options? This would work,
but I don't know if it would cause any problems in other instances.

--
Ian
--
"MBlake" wrote in message
...
Hi,
Advice on custom cell formatting please.

To sum a series of player results I use the formula
=(((COUNTIF(J9:K28,"1")*1))+((COUNTIF(J9:K28,"½")* 0.5))+((COUNTIF(J9:K28,"0")*0))+((COUNTIF(J9:K28," O")*0)))

This formula works well but I want the output to be in the format 7½
rather than the larger and unsightly 7 1/2. I can manually enter the
smaller ½ but when I use the formula to sum the socres I get the larger
half. I have tried using Custom Format but when I enter 0.½ or 0½ this
returns the correct smaller half symbol but adds 1 onto the score!.
Please could someone advise on the way to format the cells to show the
scroe as 7½ rather than 7 1/2.

Thanks,
Mickey