Change the base

[John Wright]

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?

 

[N Harkawat]

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

 

[Bernard Liengme]

correction: =INT(A1/14)&"s"&MOD(A1,14)&"lb"
There are 14 lbs in a stone

 

[John Wright]

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?