Weight conversion

[Kathy]

Can anyone tell me if possible wether there is a way to get excel to
understand stones and pounds (base unit 14) i.e. 10.12 needs to be
10.twelve not 10.onetwo

Thanks

 

[David Biddulph]

If you want to convert to stones & decimals, then =INT(A1)+MOD(A1,1)*100/14,
or if you want pounds, use =14*INT(A1)+100*MOD(A1,1)
The above assumes that you'll enter 10st 7lb as 10.07, not as 10.7.

If you're going to put in 10.7, then you'll need
=14*LEFT(A1,FIND(".",A1)-1)+RIGHT(A1,LEN(A1)-FIND(".",A1)) for pounds, or
=LEFT(A1,FIND(".",A1)-1)+RIGHT(A1,LEN(A1)-FIND(".",A1))/14 for decimal
stones.