Format cell for pounds/ounces

W

William

How can I format a cell to display pounds and ounces when only ounces
are entered?
For example, if the cell contents are "42", then I want to display
that as "2 lbs 10 oz".

Thanks,
William
 
B

Bernard Liengme

The only format that can perform arithmetic operations are date related
If A1 hold the value 42 then a cell with the formula =INT(A1/16)&" lbs " &
MOD(A1,16)& " oz"
will display as "2 lbs 10 oz".

Remember you will need to use A1 for further calculations

Alternatively use =A1/16 and format with "# ?/16" to see 2 10/16. You can do
math with such a cell

best wishes
 
S

ShaneDevenshire

Hi,

Suppose the data is in A1 then in B1 enter the formula =A1/16
Then choose Format, Cells, Number tab, Fraction, As sixteenths (8/16)
or if you want to display the words Choose the Custom category and enter

# "pounds and" ??/16 "ounces"

on the Type line.
 

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

Pounds to ounces 3
Copy cell contents, then paste into the same cell with other text. 6
Adding pounds and ounces 5
Pounds/Ounces 4
Excel does not accept text format! 0
Getting cups answer into cups _and_ 1/4 cups increments? 5
how do i format a number into stones, pounds and ounces, please? 2
Stones,Pounds and Ounces 4

Top