Change the base
 

Hi (from a guy in the UK)

I want to input data of a weight in lb into a cell and then use the data so
that it converts it to stones and lb.

For instance if i put in 100lb the other cell will say 7s2lb. (100/14=7
remainder2). 14lb in a stone.

How can i do this?

=INT(A1/14)&"s"&MOD(A1,7)&"lb"

"John Wright" <John wrote in message
...
Hi (from a guy in the UK)

I want to input data of a weight in lb into a cell and then use the data
so
that it converts it to stones and lb.

For instance if i put in 100lb the other cell will say 7s2lb. (100/14=7
remainder2). 14lb in a stone.

How can i do this?

correction: =INT(A1/14)&"s"&MOD(A1,14)&"lb"
There are 14 lbs in a stone
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"N Harkawat" wrote in message
...
=INT(A1/14)&"s"&MOD(A1,7)&"lb"

"John Wright" <John wrote in message
...
Hi (from a guy in the UK)

I want to input data of a weight in lb into a cell and then use the data
so
that it converts it to stones and lb.

For instance if i put in 100lb the other cell will say 7s2lb. (100/14=7
remainder2). 14lb in a stone.

How can i do this?

Yeah i spotted that thanks.

Now for the next question based on this same theme. If i want to graph the
results i cannot see the data as a number and therefore it won't graph. Is
there a solution?

"Bernard Liengme" wrote:

correction: =INT(A1/14)&"s"&MOD(A1,14)&"lb"
There are 14 lbs in a stone
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"N Harkawat" wrote in message
...
=INT(A1/14)&"s"&MOD(A1,7)&"lb"

"John Wright" <John wrote in message
...
Hi (from a guy in the UK)

I want to input data of a weight in lb into a cell and then use the data
so
that it converts it to stones and lb.

For instance if i put in 100lb the other cell will say 7s2lb. (100/14=7
remainder2). 14lb in a stone.

How can i do this?