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