Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suggestion for new cell formats for Feet and Inch
Many (most?) in the construction and many other industries in the U.S. use
Feet-Inch format for measurements. I wish Excel (and Access as well) could understand and convert between the various measurement formats. Normal feet-inch examples; 5'-6" (the dash is normal, but sometimes omitted) 5'6" 5'-6 1/2" (note the space before the fraction =66.5in) In the above example, I think it would be best to store the value in decimal inches, but display and allow input in the normal format. Also common is the decimal feet or decimal inch format, but in this case the " or ' is usually omitted, because the unit is understood. But, even for this case, it would be nice to handle them. Example of inch formats. (Note that some industries willl use 5/8" but most want the fraction reduced to 1/2") 1in 1 1/2in 1 In 1 1/2 In 1" 1 1/2" Examples of decimal Foot formats (never involves fractions) 1.5ft (is equal to 1'-6" or 18") 1.5 Ft 1.5' The above can be formated with the custom data format, but we need to have an easy way to convert between formats. Joe Dunfee ---------------- 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suggestion for new cell formats for Feet and Inch
"Joe Dunfee" wrote:
(Note that some industries willl use 5/8" but most want the fraction reduced to 1/2") I know this post is from a while back, but I just reread it, and see that I have an error. The above fraction 5/8" should have read 4/8". That type of fraction is used in the wood industry, and of course will reduce to 1/2". Joe Dunfee |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suggestion for new cell formats for Feet and Inch
-- I knew that that was what you meant, Joe. Thanks for your help "cadcoke3" wrote: "Joe Dunfee" wrote: (Note that some industries willl use 5/8" but most want the fraction reduced to 1/2") I know this post is from a while back, but I just reread it, and see that I have an error. The above fraction 5/8" should have read 4/8". That type of fraction is used in the wood industry, and of course will reduce to 1/2". Joe Dunfee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell format inch | Setting up and Configuration of Excel | |||
Multiply cell with foot and inch | Excel Discussion (Misc queries) | |||
How do I change chart cell from pixel to inch? | Charts and Charting in Excel |