MS Excel Cell Formatting
 

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/comm...et.f unctions

MS Excel Cell Formatting
 

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.

RDE Wrote:
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://tinyurl.com/cugg7


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=480161

MS Excel Cell Formatting
 

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

--
Ian
--
"RDE" wrote in message
...
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/comm...et.f unctions

MS Excel Cell Formatting
 

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

"RDE" wrote:

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/comm...et.f unctions