You might want to investigate User Defined Functions.
That, or convert to grams first, add, convert back to lbs

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"treboryelbis" wrote in message
...
Can anyone tell me how to automatically add lbs, ounces and drams in an
Excel
spreadsheet please.