G
Guest
How to change measurement units fron cm to inches?
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.
J
Jon Peltier
(1) Buy a different ruler.
(2) Divide by 2.54
(3) put your value in CM in cell A5, and put this formula in cell B5 to
get IN:
=CONVERT(A5,"cm","in")
- Jon
(2) Divide by 2.54
(3) put your value in CM in cell A5, and put this formula in cell B5 to
get IN:
=CONVERT(A5,"cm","in")
- Jon
G
Gord Dibben
mircea
This would be done through Windows Control Panel>Regional
Settings>Options>Customize>Measurement System>U.S.
Note: this is a global setting and will affect all programs run under Windows.
Gord Dibben Excel MVP
This would be done through Windows Control Panel>Regional
Settings>Options>Customize>Measurement System>U.S.
Note: this is a global setting and will affect all programs run under Windows.
Gord Dibben Excel MVP
P
Paul
I assumed that the OP was asking about Excel's internal measurements, for
example page margins.
example page margins.
A
ack
no built in conversion, just multiply by .39
R
Robin S.
Holly crap! .39 is not right (ask NASA).
One inch is precisely 2.54cm (you can put as many zeros as you want behind
it).
Regards,
Robin
One inch is precisely 2.54cm (you can put as many zeros as you want behind
it).
Regards,
Robin
J
Jon Peltier
Yeah, but multiplying by 0.39370 is as close as dividing by
2.5400000000000. I was of the impression that there were only two or
three zeros, not an infinite supply, but forty-five seconds on google
wouldn't give up more digits than 2.54. I hate when I "remember"
something, but can't verify it.
- Jon
2.5400000000000. I was of the impression that there were only two or
three zeros, not an infinite supply, but forty-five seconds on google
wouldn't give up more digits than 2.54. I hate when I "remember"
something, but can't verify it.
- Jon
B
Bernard V Liengme
Hi Jon,
In WWII to make all things Allied compatible the inches of UK and Britain
(and Commonwealth) were defined as 2.54 (EXACTLY). I believe it is incorrect
with an exact number to add arbitrary zeros since this could imply a
non-zero is lurking in the distance. Sorry I do not have reference for you.
Bernard
In WWII to make all things Allied compatible the inches of UK and Britain
(and Commonwealth) were defined as 2.54 (EXACTLY). I believe it is incorrect
with an exact number to add arbitrary zeros since this could imply a
non-zero is lurking in the distance. Sorry I do not have reference for you.
Bernard
J
jaf
Hi,
If you need a reference for the US it's here
http://ts.nist.gov/ts/htdocs/200/202/fs376b.htm
Download the PDF. It's Federal Standard 376b, 2.54cm or 25.4mm per inch by
an Act of Congress.
--
John
johnf 202 at hotmail dot com
| Hi Jon,
| In WWII to make all things Allied compatible the inches of UK and Britain
| (and Commonwealth) were defined as 2.54 (EXACTLY). I believe it is
incorrect
| with an exact number to add arbitrary zeros since this could imply a
| non-zero is lurking in the distance. Sorry I do not have reference for
you.
| Bernard
|
|
| | > Yeah, but multiplying by 0.39370 is as close as dividing by
| > 2.5400000000000. I was of the impression that there were only two or
| > three zeros, not an infinite supply, but forty-five seconds on google
| > wouldn't give up more digits than 2.54. I hate when I "remember"
| > something, but can't verify it.
| >
| > - Jon
| > -------
| > Jon Peltier, Microsoft Excel MVP
| > Peltier Technical Services
| > http://PeltierTech.com/Excel/Charts/
| > _______
| >
| > Robin S. wrote:
| >
| > > Holly crap! .39 is not right (ask NASA).
| > >
| > > One inch is precisely 2.54cm (you can put as many zeros as you want
| behind
| > > it).
| > >
| > > Regards,
| > >
| > > Robin
| > >
| > >
| > > | > >
| > >>no built in conversion, just multiply by .39
| > >
| > >
| > >
| >
|
|
If you need a reference for the US it's here
http://ts.nist.gov/ts/htdocs/200/202/fs376b.htm
Download the PDF. It's Federal Standard 376b, 2.54cm or 25.4mm per inch by
an Act of Congress.
--
John
johnf 202 at hotmail dot com
| Hi Jon,
| In WWII to make all things Allied compatible the inches of UK and Britain
| (and Commonwealth) were defined as 2.54 (EXACTLY). I believe it is
incorrect
| with an exact number to add arbitrary zeros since this could imply a
| non-zero is lurking in the distance. Sorry I do not have reference for
you.
| Bernard
|
|
| | > Yeah, but multiplying by 0.39370 is as close as dividing by
| > 2.5400000000000. I was of the impression that there were only two or
| > three zeros, not an infinite supply, but forty-five seconds on google
| > wouldn't give up more digits than 2.54. I hate when I "remember"
| > something, but can't verify it.
| >
| > - Jon
| > -------
| > Jon Peltier, Microsoft Excel MVP
| > Peltier Technical Services
| > http://PeltierTech.com/Excel/Charts/
| > _______
| >
| > Robin S. wrote:
| >
| > > Holly crap! .39 is not right (ask NASA).
| > >
| > > One inch is precisely 2.54cm (you can put as many zeros as you want
| behind
| > > it).
| > >
| > > Regards,
| > >
| > > Robin
| > >
| > >
| > > | > >
| > >>no built in conversion, just multiply by .39
| > >
| > >
| > >
| >
|
|
J
Jon Peltier
Glad they didn't decide to legislate pi!
- Jon
- Jon
J
jaf
What makes you think they haven't?
--
John
johnf 202 at hotmail dot com
| Glad they didn't decide to legislate pi!
|
| - Jon
| -------
| Jon Peltier, Microsoft Excel MVP
| Peltier Technical Services
| http://PeltierTech.com/Excel/Charts/
| _______
|
| jaf wrote:
|
| > Hi,
| > If you need a reference for the US it's here
| > http://ts.nist.gov/ts/htdocs/200/202/fs376b.htm
| > Download the PDF. It's Federal Standard 376b, 2.54cm or 25.4mm per inch
by
| > an Act of Congress.
| >
| >
|
--
John
johnf 202 at hotmail dot com
| Glad they didn't decide to legislate pi!
|
| - Jon
| -------
| Jon Peltier, Microsoft Excel MVP
| Peltier Technical Services
| http://PeltierTech.com/Excel/Charts/
| _______
|
| jaf wrote:
|
| > Hi,
| > If you need a reference for the US it's here
| > http://ts.nist.gov/ts/htdocs/200/202/fs376b.htm
| > Download the PDF. It's Federal Standard 376b, 2.54cm or 25.4mm per inch
by
| > an Act of Congress.
| >
| >
|
D
Dave Peterson
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.