Excel does not appear to provide a way to use architectural measurements as
numerical values. This greatly limits the users ability to perform
calculations using dimensions from architectural drawings. While Excel will
allow a user to format a number as xx'-yy.yy", a true architectural
measurement would use fractions. For example, 10'-2 1/2" should be
manipulate-able as a number (add, multiply, etc.).

Engineers and architects who use the imperial measurement system spend much
time working around this issue. Refer to the discussion at
http://www.eng-tips.com/viewthread.c...=161789&page=1 for more information
and to see how much energy is wasted on this issue. Engineering and
architectural design professionals in countries that do not use the Metric
system eagerly await Microsoft to improve the functionality of Excel in this
regard.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc