Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Struttrogers
 
Posts: n/a
Default 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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 11:24 PM
Must convert 500+ xls files to txt (tsv) KKramsch Excel Discussion (Misc queries) 1 January 5th 05 06:53 PM
How do I convert exel spreadsheet to works spreadsheet? tareco Excel Discussion (Misc queries) 3 December 28th 04 12:20 AM
Still Convert Lotus 123 to Excel 2003 becky Excel Discussion (Misc queries) 2 December 24th 04 03:14 AM
Convert Time...!convert tenths of a second Pape Excel Discussion (Misc queries) 2 December 16th 04 11:17 AM


All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"