format cell

[doug]

How do I format a cell that contains 14.8' into feet and inches
example........ 14.8' into 14' 9 5/8" ???

 

[Jim]

Look here, doug:
http://myweb.cableone.net/twodays/
and download the "Convert feet..." file. It is an addin that gives two new
UDF's: DFTOS (digital feet to standard)and STODF (standard to digital feet).

If you have 12' 6" in A2, enter =STODF(A2) in A3. The value 12.5 will be
returned. You can use digital feet to calculate,but the same is not true of
standard feet. XL "sees" 12' 6" and similar entries as text.

HTH

 

[Guest]

You cannot do this... the Format/Cells/Number lists the
only formatting choices -- and feet-inches isn't one of
them. Something similar to this was asked a couple weeks
ago... you might want to do one or more newsgroup searches
for 'feet' or similar.

You could force this issue using concatenation... but it
is not a easy as formatting the cell(s). Email me if you
want more info.

gary b

 

[Jim]

Here is another recent solution from gary b:
For example: Cells A1, B1, and C1
A1 contains feet measure
B1 contains inches measure
C1 contains formula =A1+(A2/12)
C1 is decimal equivalent of A1/A2 combination
Columns CAN be summed; formula still applies
Reverse sequence/modify formula to reverse process

 

[Dave R.]

That formula should have B1 instead of A2.

Here is another recent solution from gary b:
For example: Cells A1, B1, and C1
A1 contains feet measure
B1 contains inches measure
C1 contains formula =A1+(A2/12)
C1 is decimal equivalent of A1/A2 combination
Columns CAN be summed; formula still applies
Reverse sequence/modify formula to reverse process

 

[Jim]

If you use it, you should make the changes you indicated to return the
correct result. As I said, it is from a post by gary b.