Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Excel formula to convert stones to pounds
From:	Peter <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Mon, 26 Sep 2005 14:25:28 -0700
Content-Type:	text/plain
Parts/Attachments:	text/plain (31 lines)

This is easy. You need to separate the whole number from the fraction. Excel
has the function INT that will extract the whole number part. Thus, if you
have 12.7 in cell A5, then in cell B5 you could enter =INT(A5) and you will
see only the whole number 12. To get the fraction, just subtract the whole
number form the original and you will have 0.7 in this case. Converting the
fraction to a whole number, however, depends on how you enter the pounds
portion if it is greater than 9. How do you differentiate between 1 pound
and 10 pounds?

Hope this helps you get going.

Peter
----------------------------------
[log in to unmask]

-----Original Message-----
I keep a track of weight in an Excel spreadsheet. For years I have entered
it in stones and pounds like so:

12.7 (means 12 stone 7 pounds)

I'd like to convert it to pounds in the next cell/column. But of course 12.7
means quite a different thing in Excel! ... is there a formula that will
convert it to pounds ... a formula that will convert 12.7 to 175 lbs.

Hope you guys can help

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                  http://freepctech.com/downloads.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG