| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I convert Imperial lbs to Stones and lbs in the same cell?
Can I convert Imperial lbs to Stones and lbs in the same cell?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I convert Imperial lbs to Stones and lbs in the same cell?
Hi,
Wity pounds in a1 use this =INT(A1/14) &" "& MOD(A1,14) or =INT(A1/14) &" Stone "& MOD(A1,14)&" Pounds" Mike "John415" wrote: Can I convert Imperial lbs to Stones and lbs in the same cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal in imperial weight | Excel Discussion (Misc queries) | |||
| convert kilograms to stones AND pounds | Excel Discussion (Misc queries) | |||
| What is the Formula to Convert Imperial to Metric Measurements | Excel Worksheet Functions | |||
| how can i use imperial units eg stones and pounds | Excel Discussion (Misc queries) | |||
| How do I convert imperial to metric in Exel? | Setting up and Configuration of Excel | |||
Hybrid Mode
