Formatting cell to show body weights
 

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?

Formatting cell to show body weights
 

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?

Formatting cell to show body weights
 

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?

Formatting cell to show body weights
 

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?
--
David Biddulph

"Joel" wrote in message
...
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?

Formatting cell to show body weights
 

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?

Formatting cell to show body weights
 

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?

Formatting cell to show body weights
 

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

Formatting cell to show body weights
 

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?

Formatting cell to show body weights
 

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

"JMB" wrote:

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?