Centimeters to inches formula!

  • Thread starter Thread starter rageon75
  • Start date Start date
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
 
Simple arithmetic........

In A1 you have 254

In B1 enter =A1/2.54

Will return 100 inches.


Gord Dibben MS Excel MVP
 
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
 
=CONVERT(A1,"cm","in")

--
HTH

Bob Phillips

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

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.

Ask a Question

Similar Threads

Convert (Centimeter or Inches) to Pixel 2
Customizing change from centimeters to inches in 2
Excel How To Convert Decimal To Inches 2
Changing from inches to centimeters 4
how to convert centimeter into inch in each page margin 1
Word 2007 - How do I change ruler from metric to inches 2
Help finding the inches... 2
How to change margin from cm to inches? 2

Back
Top