Centimeters to inches formula!

R

rageon75

Is there a formula for converting centimeters into inches? I am reall
new at excel so I do not know ? Any help would be appreciated. Than
you
 
G

Gord Dibben

Simple arithmetic........

In A1 you have 254

In B1 enter =A1/2.54

Will return 100 inches.


Gord Dibben MS Excel MVP
 
P

Pete_UK

Suppose you have 10 cm and you want to convert this to inches. Enter 10
into cell A1 and in B1 enter this formula:

=A1 / 2.54

If, then, you want to convert 12 cm, just enter 12 into cell A1 and you
will have your answer in B1.

Hope this helps.

Pete
 
B

Bob Phillips

=CONVERT(A1,"cm","in")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top