How do I convert imperial to metric in Exel?

S

Struttrogers

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i change to metric tab stops in word 2007 3
custom format metric/imperial 3
imperial vs metric? 1
How does one switch from metric to imperial? 2
Change from Imperial to metric in tables in word 2
How do you export both parts of a 2-part metric 1
Changing page sizing and rulers from Imperial system to Metric 1
Converting Metric to Imperial 8

Top