How do I format a cell to show weight in stones and pounds?

  • Thread starter Thread starter Southwaterdave
  • Start date Start date
S

Southwaterdave

I am trying to set up a spreadsheet in Excel to record my weight, but if I
enter, for example, 12:05 to indicate 12 stone 5 pounds, it thinks this is a
time. Any suggestions?
 
Hi

One thing you could do is enter the values in adjacent columns
Enter 12 in column A
Format column B>Cells>Number>Custom>00>Alignment>Horizontal>Left
Select columns A and B>Format>Columns>Width>2.45

If you are trying to show gains or losses, then you would need to be using a
custom formula anyway to deal with Stones and pounds, so separate columns
might help.
In cell C2
=((A2*14)+B2)-((A1*14)+B1)
 
Since a stone is about 14 pounds, enter:
12 5/14

Note only a single space between the integer and the fraction.
 
Back
Top