Tom,

No can do with a format, methinks. How about displaying pounds and ounces
in another cell (column)?
=INT(A2) & " lbs " & MOD(A2,1)*16 & " oz"

This yields a text string, so you can't do any math on it; use the original
(A2) cell for that.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tom" wrote in message
...
I have a formula that I would like to display the result as pounds and
ounces. I created and custom format that will display as (for example)
"14.25
lbs" but I would like it to display as 14 lbs 4 oz. It must display as a
number and not text. Any help would be great!

Thanks,