Weight conversion
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 |
Weight conversion
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. -- David Biddulph "Kathy" wrote in message ... 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 |
All times are GMT +1. The time now is 01:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com