Formatting cell to show body weights

[Guest]

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?

 

[David Biddulph]

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

 

[Guest]

did you try in the format menu Cell - Number - custom. You probably want to
add ##st;##lb

 

[David Biddulph]

Have you tried that suggestion, Joel? If so, what settings did you need to
apply to get Excel to accept it and to allow the numbers to be plotted in a
graph?

 

[Guest]

Thanks Joel, but when I try the suggestion you made it brings up the error
message 'MS Excel cannot use the number format you typed'

 

[Guest]

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!

 

[Dave Peterson]

Try:
##\st ##l\b

But the underlying value will still be 1213.

 

[Guest]

You could go to

# ??/28

1/28 is equal to 0.5/14

 

[Guest]

Thanks JMB for such a nice simple answer. Why do I always expect things to be
more complicated than they are?!!