Need a book? Engineering books recommendations...

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

RE: Steel-Detail: feet and inches in Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Title: Message
If that doesn't work, consider using the concatenate function - which is the best function on the block if you ask me...  =concatenate(Feetcell, "'-",inchescell,""")
-----Original Message-----
From: Bill Allen [mailto:T.W.Allen(--nospam--at)]
Sent: Tuesday, March 11, 2003 3:48 PM
To: seaint(--nospam--at)
Subject: RE: Steel-Detail: feet and inches in Excel

That method doesn't work on my machine.
FWIW, this is one area where Mathcad is better than Excel.
T. William (Bill) Allen, S.E. (CA #2607)
San Juan Capistrano, CA
-----Original Message-----
From: Tim Allison [mailto:AllisoT(--nospam--at)]
Sent: Tuesday, March 11, 2003 1:08 PM
To: seaint(--nospam--at)
Subject: Re: Steel-Detail: feet and inches in Excel

You can go to Format Cells, then Number, then select Custom.  In the box where it says Type:, remove "General" and enter "#ft ##in".  You then just combine the feet and inches into one large number - for 23'-4", enter 2304.  It should output "23ft 4in".  You have to use 2 digits for the inches.  Otherwise, you can merge the two cells into a third.

>>> kspeoples(--nospam--at) 03/11/03 12:28PM >>>
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,

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

[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.
Visit for more info.
...the innovative minds at CadVantage - see the NEW Pay-per-Use version of
CVSpro8 at or the NEW 'SteelTools' at 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
Go to:

To reply to the entire list simply send your message to:

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at:
*   This email was sent to you via Structural Engineers
*   Association of Southern California (SEAOSC) server. To
*   subscribe (no fee) or UnSubscribe, please go to:
*   Questions to seaint-ad(--nospam--at) 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:
******* ****** ****** ****** ******* ****** ****** ********