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]
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
******* ****** ****** ****** ******* ****** ****** ********