I am trying to type out and chart weights that are in pounds and ounces. I have already learned to custom format cells 0"lbs".00"oz" so 10.15 or 10lb 15oz shows as 10lbs.15oz
Main issue with that is excel does not recognize the 15 ounces and 15 ounces but as 1.5 ounces and charts it as such which is a big issue when keeping track of ounces (it is a small animal)
It is probably easier to convert to decimal or kg. Through this forum I have found this formula: =LEFT(A1, SEARCH(" ",A1,1))+(MID(A1,FIND(" lbs",A1)+2,3)) But that does not seem to work, at least not for something such as 1 lbs Am I typing it out wrong? There seems to be plenty of info of converting decimals to lbs and many other conversions but not this.