Formula to change 'Stones - Pounds' to Pounds?

[papillon]

Hi All,
Does anyone know of a formula to change imperial stones and pounds to just pounds eg 13 stones 3 lbs = 185lbs ? (14 pounds to a stone)
Thanks,
papillon

 

[AlohaJulio]

Even if the stones.pounds are text, I think the following will do what you are looking for:
=INT(A1)*14+(A1-INT(A1))*10

Never mind, I missed page two or the replies, sorry for being so slow on the uptake.

 

[rrdonutz]

Originally posted by AlohaJulio:
Even if the stones.pounds are text, I think the following will do what you are looking for:
=INT(A1)*14+(A1-INT(A1))*10

Your formula will not work for values such as 11.12, 3.13, 52.11, 127.10, etc. Of course, 'xyz.10' has to be entered as text, or Excel will change it to 'xyz.1'.

(And you're welcome, Red Admiral/papillon.)