| 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?
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 | |||
Hybrid Mode
