E
exntluser
In Excel 2007 is it possible to format cells for weight, such as stones &
lbs?
e.g. 14 lbs = 1 stone
lbs?
e.g. 14 lbs = 1 stone
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
You could use custom format # ??/14
The you would type, for example 12 2/14 for 12 stone 2 lbs
best wishes
The you would type, for example 12 2/14 for 12 stone 2 lbs
best wishes
E
exntluser
Please excuse my lack of knowledge on this subject, but how would I go aboutBernard Liengme said:You could use custom format # ??/14
The you would type, for example 12 2/14 for 12 stone 2 lbs
best wishes
using custom format # ??/14 ?
B
Bernard Liengme
Let's assume you are using Excel2003 (or earlier)
Select the cells to be formatted
On the Menu use Format | Format Cells and click "Custom" on left side of
dialog
In Custom dialog, locate the Type box and type in there: # ??/14
More info at http://office.microsoft.com/en-ca/excel/HP051995001033.aspx
best wishes
Select the cells to be formatted
On the Menu use Format | Format Cells and click "Custom" on left side of
dialog
In Custom dialog, locate the Type box and type in there: # ??/14
More info at http://office.microsoft.com/en-ca/excel/HP051995001033.aspx
best wishes
G
Gord Dibben
Not a format.............needs a helper cell.
=INT(A3/14)&" Stones "&ROUND((A3/14-INT(A3/14))*14,0)&" lbs"
Gord Dibben MS Excel MVP
=INT(A3/14)&" Stones "&ROUND((A3/14-INT(A3/14))*14,0)&" lbs"
Gord Dibben MS Excel MVP