cm/inches

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

Paul

I assumed that the OP was asking about Excel's internal measurements, for
example page margins.
 
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
 
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
 
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
 
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
| > >
| > >
| > >
| >
|
|
 
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.
| >
| >
|
 
Top