Format cell for pounds/ounces

  • Thread starter Thread starter William
  • Start date Start date
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
 
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
 
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.
 
Back
Top