| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Must convert 500+ xls files to txt (tsv) | Excel Discussion (Misc queries) | |||
| How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
| Still Convert Lotus 123 to Excel 2003 | Excel Discussion (Misc queries) | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Linear Mode
