Metric Conversion

[Gary Fitz]

How to convert all data from inches to metric???

 

[Chip Pearson]

Gary,

Assuming you want to convert to centimeters, enter 2.54 in an
empty cell and copy that cell. Then, select the cells you want to
convert. Go to the Edit menu, choose Paste Special, and choose
the Divide operation. Click OK.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Peo Sjoblom]

Multiply the inches with 0.0254 (roughly)

or use ATP function convert (needs to be installed but comes with excel)

=CONVERT(A2,"in","m")

where A2 holds the inches

 

[Norman Harker]

Hi Gary!

There's a variety of metric dimensions you can convert to.

CONVERT allows a comprehensive range using prefixes to the basic m for
meters

Example:
=CONVERT(1,"in","m")
Returns 0.0254 meters

Or:
=CONVERT(1,"in","cm")
Returns 2.54 centimeters

Here's the list of prefixes used for metric conversions

Prefix Abbreviations for metric: "E" = 1E+18 = exa; "P" = 1E+15 =
peta; "T" 1E+12 = tera; "G" = 1E+09 = giga; "M" = 1E+06 = mega; "k" =
1E+03 = kilo; "h" = 1E+02 = hecto; "e" = 1E+01 = dekao; "d" = 1E-01 =
deci; "c"=1E-02 = centi; "m" = 1E-03 = milli; "u" = 1E-06 = micro; "n"
= 1E-09 = nano; "p" = 1E-12 = pico; "f" = 1E-15 = femto; "a" = 1E-18 =
atto

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bernard Liengme]

The value 2.54 to convert inches to centimetres is not 'rough'; it is exact.
The inch (US, UK, etc) is defined as 2.54 cm - done during WWII to get
uniform screw threads etc.

 

[Peo Sjoblom]

Thanks, I didn't know that. Regardless, imperial measurement should go down
the drain,
they mush have been invented by 6 fingered Brits <g>

 

[Norman Harker]

Hi Peo!

Re: "they mush have been invented by 6 fingered Brits <g>"

Who only need 2 of those fingers to reply to your suggestion! <vbg>

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.