Cell Format
Cell Format
(OP)
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
Thanks
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Cell Format
http://www.mrexcel.com/tip012.shtml
RE: Cell Format
RE: Cell Format
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.
RE: Cell Format
GREAT TIPS.
yli