See if this page of David McRitchie's helps:

http://www.mvps.org/dmcritchie/excel....htm#carpentry

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"sip8316" wrote in message
...
Thanks,
That helped some, I changed how I did things now and now my only quesion
is...is there a number formating opition that would let you type in a
decimal
form of feet and inches (like 2.06 for 2 feet 6 inches) and have it
displayed
as 2ft6in.
As I said before the closest I've come is typing #"ft" ?/12"in" but then I
get 2ft7/12in, not 6.



"Duke Carey" wrote:

Chip Pearson has some instructions on this at his website:

http://www.cpearson.com/excel/fractional.htm



"Sip8316" wrote:

I am completing a project in which I need to take data collected on
window
sizes and calculate the total area. The data is in Feet and Inches. If
possibe I want to be able to plug the data into excell and have it
formated
so it displays 2ft 6in but is still in data form.

I have tried to do this by number formating like this #"ft" ?/12"in"
but if
I typed in 2 feet and 6 inches (2.6) I get 2ft7/12in in the cell. I
realize
why but I don't know how to format it in a way that excell will
interpret it
as 2ft6in. Any help would be great.

After entering the height and width that way I want to calculate the
area in
one cell. From what I've seen the data has to be converted to decimal
form
to cacluate and then I would want the area to be put into feet and inces
again. I don't know how to do this without using many multiple cells,
one to
convert it to decimal, another to multiply the area and another to put
that
back as square feet.

Please Help