![]() |
How 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. ToolsAdd-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 SpecialDivideOKEsc. This will convert those cells to kg. And miles to km is miles/.6213712 Gord Dibben Excel MVP On Sun, 23 Jan 2005 09:31:01 -0800, Struttrogers wrote: 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. |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com