Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format a cell to show weight in stones and pounds?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format a cell to show weight in stones and pounds?
Hi
One thing you could do is enter the values in adjacent columns Enter 12 in column A Format column BCellsNumberCustom00AlignmentHorizontalLef t Select columns A and BFormatColumnsWidth2.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) -- Regards Roger Govier "Southwaterdave" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format a cell to show weight in stones and pounds?
Since a stone is about 14 pounds, enter:
12 5/14 Note only a single space between the integer and the fraction. -- Gary''s Student - gsnu200841 "Southwaterdave" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i format a number into stones, pounds and ounces, please? | Excel Discussion (Misc queries) | |||
How to format in stones & pounds and then present on chart | Excel Discussion (Misc queries) | |||
How do I format cells to accept stones and pounds? | Excel Discussion (Misc queries) | |||
how can i use imperial units eg stones and pounds | Excel Discussion (Misc queries) | |||
I've got a formula for stones and pounds - how do I get an excel . | Charts and Charting in Excel |