×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Cell Format

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

RE: Cell Format

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

RE: Cell Format

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.

RE: Cell Format

(OP)
Thanks Stick1 !

GREAT TIPS.

yli

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources