Formatting cell to show body weights

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
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'
 
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!
 
Thanks JMB for such a nice simple answer. Why do I always expect things to be
more complicated than they are?!!
 
Back
Top