 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Kilos
Hi, Is there a function or a quick way of coverting kilos into Stones and pounds? Thanks From the Help file: =CONVERT(1.0, "lbm", "kg") Converts 1 pound mass to kilograms (0.453592) If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. So you need: =CONVERT(1,"kg","lbm") ... then divide by 14 to get stones  SignatureAndy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - > Hi, > > Is there a function or a quick way of coverting kilos into Stones and > pounds? > > Thanks If the kilos are in cell A1, then this in cell B1 =TEXT(A1/0.453592/14,"00")&" Stone - "&TEXT(MOD(A1/0.453592,14),"00")&" lbs" HTH SignatureKevin James. Tua'r Goleuni | Hi, | | Is there a function or a quick way of coverting kilos into Stones and | pounds? | | Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.