Need a book? Engineering books recommendations...

# RE: Steel-Detail: feet and inches in Excel

• To: <seaint(--nospam--at)seaint.org>
• Subject: RE: Steel-Detail: feet and inches in Excel
• From: "Jeremy Kuhn" <JKuhn(--nospam--at)americancrane.com>
• Date: Tue, 11 Mar 2003 15:56:35 -0500

```Ken,

I don't know what could be easier than using two cells - seems the most logical.

Any other way that I can think of would be no easier...for example if you want to just make inputting easier you could enter the feet and inches separated by a decimal point - for example 25 feet 7 inches would be written as 25.7 (not the decimal equivalent 25.583 ! ) then enter formulae into other cells to separate the feet from the inches.  Could become a complicated formula if you want to include fractions of inches (but it is possible).

My suggestion is to just keep using 2 cells - hitting the tab button after entering the feet and prior to entering the inches is just as easy as hitting the decimal point or any other character.

Jeremy Kuhn, P.E.
Project Engineer
American Crane
610-385-6061  Ext. 270

-----Original Message-----
From: 	Ken Peoples [mailto:kspeoples(--nospam--at)lvta.net]
Sent:	Tuesday, March 11, 2003 12:28 PM
To:	Steel Detail; Seaint
Subject:	Steel-Detail: feet and inches in Excel

Do any of you know of a simple way of inputting feet and inches in Excel?  I currently separate the two into two different cells but think that there must be an easier way.  (I don't want to convert to decimal feet or use all inches)
Ken

Kenneth S. Peoples, P. E.
Lehigh Valley Technical Associates, Inc.
Northampton, PA 18067-9039
Phone: (610) 262-6345
Fax: (610) 262-8188
e-mail: kpeoples(--nospam--at)lvta.net

[Non-text portions of this message have been removed]

---- Steel-Detail List Sponsored by -------------------------------------
StrucSoft Solutions offers you accessibility to true 3D detailing for
less than \$6000 per license. PROSTEEL 3D is an AutoCAD-based modeling and
detailing software based on ARX technology; also features COM technology.
-------------------------------------------------------------
...the innovative minds at CadVantage - see the NEW Pay-per-Use version of
CVSpro8 at www.steeldetails.com/payperuse.htm or the NEW 'SteelTools' at
Steel-Link.com. Only pay for what you produce using high-end, automated
detailing software for about \$8 per sheet.  Call 704-344-9644.
-------------------------------------------------------------
Find out how you can advertise here to over 1200 subscribers

************************************************************
steel-detail(--nospam--at)yahoogroups.com

To unsubscribe from this group, send an email to:
Steel-Detail-unsubscribe(--nospam--at)yahoogroups.com

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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