You could go to

# ??/28

1/28 is equal to 0.5/14

"Margaret" wrote:

Thanks David. This has worked - after a fashion!. As well as setting the
format as you recommend I also have to type 12 13/14 in the cell and MS excel
converts the number to several decimal places whilst still displaying what I
want in the cell and the chart. Provided I can remember this I will be fine!
I just need to work out how to show 1/2lb (0.5lb) for myself - I'm just over
8st now so every 1/2lb makes a difference!

"David Biddulph" wrote:

You could use a custom format of # ??/14 to show as 12 13/14
--
David Biddulph

"Margaret" wrote in message
...
I am using Excel 2003. I want to create a graph to record weekly weight
loss
but cannot find a number format for English weights - which are measured
in
Stones and Pounds (1st = 14lb). When I try to input my boyfriend's weight
as
12st 13lb it shows it as 12.13 which is just over 12 stone instead of just
under 13 stone. Is there a conversion I can do please?