Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

Re: feet inch calculator

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Rajendran,

What would you do to have that formula give you the proper fraction of an
inch?

Also does anyone know if there is a setting so that you don't have to enter
an "=" sign before a formula. In Lotus 123 you don't have to but you have to
precede text with a ' symbol.

Rand

----- Original Message ----- 
From: "Padmanabhan Rajendran" <rakamaka(--nospam--at)yahoo.com>
To: <seaint(--nospam--at)seaint.org>
Sent: Thursday, May 06, 2004 12:21 PM
Subject: RE: feet inch calculator


> With the decimal number in cell A1, use the following formula.
>
> =INT(A1)&CHAR(39)&"-"&(A1-INT(A1))*12&CHAR(34)
>
> Rajendran
>
> Dean Briggs <dean(--nospam--at)amfabsteel.com> wrote:
> Thanks for the repost. Do you have the formula to convert decimal to the
text string?
> Dean
>
> -----Original Message-----
> From: Dickey, David [mailto:David.Dickey(--nospam--at)mhgrp.com]
> Sent: Thursday, May 06, 2004 9:34 AM
> To: seaint(--nospam--at)seaint.org
> Subject: RE: feet inch calculator
>
>
> Someone posted a formula on this list (don't remember who it was or else I
would give credit) that you can use in Excel to convert a text string of
feet and inches (i.e. 12'-4 15/16") to decimal format.
>
> Type your text string in Cell A1 then paste this formula in.
>
>
=LEFT(A1,FIND(CHAR(39),A1)-1)+(MID(A1,FIND("-",A1)+1,FIND(CHAR(34),A1)-FIND(
"-",A1)-1))/12
>
>
> -----Original Message-----
> From: rupali-iit [mailto:rupali-iit(--nospam--at)indiatimes.com]
> Sent: Thursday, May 06, 2004 1:10 AM
> To: seaint(--nospam--at)seaint.org
> Subject: feet inch calculator
>
>
> hi friends, i would like to know if there is any feet-inch calculator for
downloading(computer version) thanks
>
> ******* ****** ******* ******** ******* ******* ******* ***
> * Read list FAQ at: http://www.seaint.org/list_FAQ.asp
> *
> * This email was sent to you via Structural Engineers
> * Association of Southern California (SEAOSC) server. To
> * subscribe (no fee) or UnSubscribe, please go to:
> *
> * http://www.seaint.org/sealist1.asp
> *
> * Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
> * send to the list is public domain and may be re-posted
> * without your permission. Make sure you visit our web
> * site at: http://www.seaint.org
> ******* ****** ****** ****** ******* ****** ****** ********
>
> ******* ****** ******* ******** ******* ******* ******* ***
> * Read list FAQ at: http://www.seaint.org/list_FAQ.asp
> *
> * This email was sent to you via Structural Engineers
> * Association of Southern California (SEAOSC) server. To
> * subscribe (no fee) or UnSubscribe, please go to:
> *
> * http://www.seaint.org/sealist1.asp
> *
> * Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
> * send to the list is public domain and may be re-posted
> * without your permission. Make sure you visit our web
> * site at: http://www.seaint.org
> ******* ****** ****** ****** ******* ****** ****** ********
>
> ---------------------------------
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs



******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org 
******* ****** ****** ****** ******* ****** ****** ********