ounces vs. pounds

J

JIMIMJ

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

Dave Peterson

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
 
R

Rick Rothstein

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate weight (ounces into pounds) in Excell? 4
Weighted % Complete calculation 1
Format cell for pounds/ounces 2
Does anyone have a template to convert Kilos to Pounds & Ounces 4
How to change no. of decimal places displayed depending on cell va 0
Copy cell contents, then paste into the same cell with other text. 6
adding pounds and ounces 8
how do i format a number into stones, pounds and ounces, please? 2

Top