Cell Format 1

[yli]

I would like to format the cell in such way that if I type in 2.5, the cell will show as 2'-6", can anyone tell me how?

Thanks

 

[handleman]

I don't think you can do this with a format. Check out

http://www.mrexcel.com/tip012.shtml

 

[yli]

Thanks Handleman, I appreciate your response and I will try it out.

 

[stick1]

Also take a look at:

http://www.mvps.org/dmcritchie/excel/formula.htm

Try formatting cell as: # ??/12\" under custom format. Typing in 2.5 would result in 2 6/12"

Or type value in column A, in the same row in column B, put the formula: =INT(A3)&"'  "&ROUND(12*MOD(A3,1),1)&"''"

So in A1 type 2.5, and in cell B1 2' 6" will appear.

 

[yli]

Thanks Stick1 !

GREAT TIPS.

yli