View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default convert decimal in imperial weight

In A1:
=321.08/24 displays the lbs (fractional)
In B1:
=INT(A1) displays integer lbs
In C1:
=CONVERT(A1-B1,"lbm","ozm") displays the residual ozs.


--
Gary''s Student - gsnu200860


"Roy Gudgeon" wrote:

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