Is there a formula for converting centimeters into inches? I am really new at excel so I do not know ? Any help would be appreciated. Thank you.
Is there a formula for converting centimeters into inches? I am really new at excel so I do not know ? Any help would be appreciated. Thank you.
There are 2.54 cm per inch
Ben Van Johnson
Can you give me an example of the formula. I really new at excel. Thank you.
Simple arithmetic........
In A1 you have 254
In B1 enter =A1/2.54
Will return 100 inches.
Gord Dibben MS Excel MVP
On Fri, 11 Aug 2006 19:23:16 -0400, rageon75
<[email protected]> wrote:
>
>Is there a formula for converting centimeters into inches? I am really
>new at excel so I do not know ? Any help would be appreciated. Thank
>you.
Thank you so much. I really appreciate it!
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
rageon75 wrote:
> Can you give me an example of the formula. I really new at excel. Thank
> you.
>
>
> --
> rageon75
> ------------------------------------------------------------------------
> rageon75's Profile: http://www.excelforum.com/member.php...o&userid=31862
> View this thread: http://www.excelforum.com/showthread...hreadid=570955
=CONVERT(A1,"cm","in")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"rageon75" <[email protected]> wrote in
message news:[email protected]...
>
> Is there a formula for converting centimeters into inches? I am really
> new at excel so I do not know ? Any help would be appreciated. Thank
> you.
>
>
> --
> rageon75
> ------------------------------------------------------------------------
> rageon75's Profile:
http://www.excelforum.com/member.php...o&userid=31862
> View this thread: http://www.excelforum.com/showthread...hreadid=570955
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks