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)

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)

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)