Decimal pounds into Pounds and oz
I have been searching for a formula to convert decimal pounds into pounds and oz', but so far with no luck.
Would anyone here know how to accomplish this ?
Example:
Converting 34,7 lb into 34lb 11.2oz
iMac Pro
Here's an example:
The formula below the table is entered in cell C2, then filled down that column to show the results for each tenth of a pound (and for a value with the fractional pounds expressed in hundredth in the last row.
The results are Text values, and are not in a number format recognized by Numbers, preventing them from being used in further calculations.
Regards,
Barry