You can use the DOLLARDE to covert kgs to lbs.oz where the integer
portion of the result is the number of pounds and the fractional
portion is the number of ounces. E.g.,
10.01 = 10 lbs 01 oz
10.10 = 10 lbs 10 oz
=DOLLARFR(A1*2.2046,16)
where A1 is the kg value. Note that, for example, a result of 10.01
does not mean 10 + (1/100) lbs, it means 10 lbs + 01 oz. Similarly,
10.10 does not mean 10 + (1/10), it means 10 lbs + 10 oz.
To convert these values to values that can be used in calculations,
use
=DOLLARDE(B1,16)
These functions take their name from their use in working the stock
prices which are often expressed in eighthts of a dollar.
In Excel 2003 and earlier, you'll need to load the Analysis Tool Pack.
Go to the Tools menu, choose Add Ins, and check "Analysis Tool Pack"
in the list. In Excel 2007 and later, these functions are native to
Excel and do not require an add-in.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)