 |
 | 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 / Setup / January 2005How do I convert imperial to metric in Exel?
I have just downloaded a Fitness Plan template but I prefer the metric system as I live in Denmark and I am used to metric. Check out the CONVERT Function that is available in the Analysis Toolpak add-in. Tools>Add-ins. Checkmark Anaylysis Toolpak.........not Analysis Toolpak - VBA Also the standard for lbs to kg is lbs/2.20462 e.g. you have a bunch of cells in lbs. Enter 2.20462 in an unused cell. Copy that cell then select your lbs cells and Paste Special>Divide>OK>Esc. This will convert those cells to kg. And miles to km is miles/.6213712 Gord Dibben Excel MVP >I have just downloaded a Fitness Plan template but I prefer the metric system >as I live in Denmark and I am used to metric. |
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.