| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal in imperial weight
perfect Jim, thanks to you and the other respondees
-- thanks Roy "Jim Cone" wrote: That should be 13.00333. The worksheet function "Convert" could be used or with the result of your division in cell A1 then... =INT(A1)&" pounds and " &ROUND((A1-INT(A1))*16,2)&" ounces" -- Jim Cone Portland, Oregon USA "Roy Gudgeon" wrote in message ... Hi I have a number, say 312.08 that I want to divide by say 24 and report as weight in pounds and ounces simple division reports 13.0333 -- thanks in anticipation Roy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function To Convert Liters To Imperial Gallons & Vice Versa | Excel Worksheet Functions | |||
| What is the Formula to Convert Imperial to Metric Measurements | Excel Worksheet Functions | |||
| How do I convert imperial to metric in Exel? | Setting up and Configuration of Excel | |||
| Imperial weight | Charts and Charting in Excel | |||
| How do I use Excel's convert function for apothecary weight? | Excel Worksheet Functions | |||
![Roy Gudgeon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
