G
Gary Fitz
How to convert all data from inches to metric???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
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
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
P
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
or use ATP function convert (needs to be installed but comes with excel)
=CONVERT(A2,"in","m")
where A2 holds the inches
N
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.
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.
B
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.
The inch (US, UK, etc) is defined as 2.54 cm - done during WWII to get
uniform screw threads etc.
P
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>
the drain,
they mush have been invented by 6 fingered Brits <g>
N
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.
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.