How do I format cells to accept stones and pounds?
 

I am trying to set up a chart showing weight comparisons in stones and pounds.

How do I format cells to accept values e.g. 14st 6lb etc? (I don't just want
to put in the total pounds value of e.g. 202 instead of 14st 6lb)

How do I format cells to accept stones and pounds?
 

In A1 enter:
202

In B1 enter:
=A1*0.0714285781774163


In C1 enter:
=INT(B1)


In D1 enter:
=INT((B1-INT(B1))/0.0714285781774163)


In E1 enter:
=C1 & " st " & D1 & " lb"


and you will see:
202 14.42857279 14 6 14 st 6 lb

You can hide the intermediate columns if you like.
--
Gary''s Student


"Excelnewbie" wrote:

I am trying to set up a chart showing weight comparisons in stones and pounds.

How do I format cells to accept values e.g. 14st 6lb etc? (I don't just want
to put in the total pounds value of e.g. 202 instead of 14st 6lb)

How do I format cells to accept stones and pounds?
 

Alternatively format the cells with custom format # ??/14
Now you can enter, for example, 12 5/14 for 12 stone 5 lbs (I remember that
was my weight when I was 21!)
The advantage being you can do arithmetic on these values.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Excelnewbie" wrote in message
...
I am trying to set up a chart showing weight comparisons in stones and
pounds.

How do I format cells to accept values e.g. 14st 6lb etc? (I don't just
want
to put in the total pounds value of e.g. 202 instead of 14st 6lb)