| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do a kg to stone convertion in excel
another error on my part...change the 10,0 to 14,0
FLKulchar "Bernard Liengme" wrote in message ... As an alternative to Bill's answer A3 has weight in kilograms =A3*0.071429 then format with Custom format # ??/14 In this way, 100 kg displays as 7 2/14 meaning 7 stone 2 lbs best wishes from Canada -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Michael Eastwood" <Michael wrote in message ... I tried doing a v lookup for a kg to stone/pound convertion. The problem arrises because there is 14 lbs to a stone. Excel dosent recoznise 1 stone 12 lbs for example |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data as Stone, pounds and ounces | Excel Discussion (Misc queries) | |||
| Convertion of excel to CSV format | Excel Discussion (Misc queries) | |||
| excel to text convertion | Excel Discussion (Misc queries) | |||
| Date convertion | Excel Discussion (Misc queries) | |||
| Convertion | New Users to Excel | |||
Threaded Mode
