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: "YI" <YI(--nospam--at)summit-sr.com>
• Date: Tue, 11 Mar 2003 13:53:30 -0800

```I don't think there is a quick way of doing what you want, i.e.
formatting cells to a feet inch system, and not using some kind of
decimal number.  If you are working on a spreadsheet with a lot of input
in feet-inch, then the two-cell solution is probably your best choice.
If you are making a spreadsheet with few feet-inch input, and want a
clean interface, don't want the user to be confused with the special
input requirement, you'll have to create a custom formula or VB macro to
convert the text string such as "12' 6 3/4"" to a decimal number and
proceed with the calculation.

Y i  Y a n g  P.E.
Summit Engineering
Santa Rosa, California

-----Original Message-----
From: Jeremy Kuhn [mailto:JKuhn(--nospam--at)americancrane.com]
Sent: Tuesday, March 11, 2003 12:57 PM
To: seaint(--nospam--at)seaint.org
Subject: RE: Steel-Detail: feet and inches in Excel

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) Thanks in advance, 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]

-------------------------------------
StrucSoft Solutions offers you accessibility to true 3D detailing for
and detailing software based on ARX technology; also features COM
-------------------------------------------------------------
...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
*   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