perfect Jim, thanks to you and the other respondees
--
thanks
Roy


"Jim Cone" wrote:

That should be 13.00333.
The worksheet function "Convert" could be used or
with the result of your division in cell A1 then...

=INT(A1)&" pounds and " &ROUND((A1-INT(A1))*16,2)&" ounces"
--
Jim Cone
Portland, Oregon USA



"Roy Gudgeon"

wrote in message
...
Hi
I have a number, say 312.08 that I want to divide by say 24
and report as weight in pounds and ounces
simple division reports 13.0333
--
thanks in anticipation
Roy