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'

"Joel" wrote:

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

"Margaret" wrote:

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?

Try:
##\st ##l\b

But the underlying value will still be 1213.

Margaret wrote:

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'

"Joel" wrote:

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

"Margaret" wrote:

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?

--

Dave Peterson