Hi All,
Is there a way to format a cell so that I can enter a "weight" i.e. 15 Stone 8 pounds and 3 ounces as 15.8.3 and then have a conversion cell which calculates this as pounds and ounces? i.e. 218 lbs 3 ounces or 218.3 (the figure after the decimal point ".3" is measured in 16ths to represent 3/16)
Thank you