×
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

Concatenate function with numerical cells

Concatenate function with numerical cells

Concatenate function with numerical cells

(OP)
When I usse the concatenate function and include a cell with a numerical value (which is the result of a calculation) the result is a sentence with a number with lots of decimal points.  Sometimes I want the numerical value to be formated as a fraction or maybe a value with two decimel points.  I can't find a way to have the numerical cell format carry over into the result of the concatenate function.  For example, I want "Use 15/16 inch thick plate", not "Use 0.9375 inch thick plate".  Any suggestions would be appreciated.  Thank you.  

Joe Tank

RE: Concatenate function with numerical cells

Excel stores numeric values as floating-point numbers.

Cell formatting changes the way that value is displayed.  Formatting does not change the value.

Concatenate is a text function.  If you feed it a numeric value, it changes the value to a string, and uses that.

You need to be more explicit in building your concatenated string by telling Excel exactly what you want to do.

For example:

CODE

="use "&TEXT(A1,"# ?/?")&" plate."

 

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