Special format for feet - inches in a cell

[Bothell John]

Many html tables list height as x-yy where x is feet and yy is inches. Excel
imports this as a date. In looking at cell number formats there is no option
to display either a feet-inches 'number' or an inches number as x-yy. (I will
write up a separate item about Excel importing the feet and inches as dates.)

----------------
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/com...6-420e0c077547&dg=microsoft.public.excel.misc

 

[Bruce Sinclair]

Many html tables list height as x-yy where x is feet and yy is inches. Excel
imports this as a date. In looking at cell number formats there is no option
to display either a feet-inches 'number' or an inches number as x-yy. (I will
write up a separate item about Excel importing the feet and inches as dates.)

Um ... feet and inches are seriously out of date units.
If you use meters, your problem vanishes ... as they are just numbers.
Other obvious option (if you really want to use feet/inches) would be to use
one column for feet and one for inches.

----------------
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/community/en-us/default.mspx?mid=eec05630-e1ff-
48cb-b656-420e0c077547&dg=microsoft.public.excel.misc

Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)