MS Excel Cell Formatting

[Guest]

Please explain how I can add a dimension format to the cell format section.
I need a format that will allow me to record dimensions (feet-inches) in a
single field. The format style would be conveniant of it was similar popular
CAD/CAM packages.

----------------
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...dg=microsoft.public.excel.worksheet.functions

 

[qwopzxnm]

I'm not sure if there is a dimension format in excel but you could try
this...

Have columns A, B, and C be your Heigh, Width, and Depth respectively.

Then you could have column D with a formula that looks something like

=A1&"H x "&B1"W x "C1&"D"

Hope this helps.

 

[Ian]

Whats wrong with typing in 12' 3", or do you need to perform calculations on
it?

 

[Guest]

try response from GerryK on 1/6/2005 for "Calculate formulas with feet &
inches"
he gave a website from mrexel. com. I found an error on the solution with
negative numbers and revised my copy to correct it, but otherwise it works
great