View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default ounces vs. pounds

I'd use two columns -- one for the pounds and one for the ounces.

Or enter the weights like:

127 15/16
(for 127 pounds and 15 ounces)

Give it a nice format (Format|cell|fraction)
or even a custom format of:
##0 ??/16





JIMIMJ wrote:

I need a formula to calulate a individuals within a group weight loss. When
I use the . it only calcualtes to 10.


--

Dave Peterson