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