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

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

When you use what "." and what is "it" that only calculates to 10? You
should probably tell us a little more about what you have and what you want
afterwards (examples would help).

--
Rick (MVP - Excel)



"JIMIMJ" wrote in message
...
I need a formula to calulate a individuals within a group weight loss.
When
I use the . it only calcualtes to 10.