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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb 4
How to format in stones & pounds and then present on chart 2
Formatting for Weights pounds & ounces 2
Query Formula (stones and pounds to kg's) 1
Formatting cell to show body weights 8
how do i convert weight (stones+llbs) to llbs? 1
how do i use excel to calculate weight (as in stone and lbs)? 6
I need serious help Worksheet functions 4

Back
Top