×
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

Excel Formatting

Excel Formatting

Excel Formatting

(OP)
Excel97 SR-2.  

Cell C47 contains the following ="Text"&E45&"% Text" where E45 has an equation formatted to display a Number with 1 decimal place.  How do I get my text cell to use the same formatting.  Right now I get umpteen decimals.

Thanks,

Roger

RE: Excel Formatting

The only way I know of is to change formula to

="Text"&Round(E45;Number_of_digits)&"% Text"

; may be , depending on your regional settings

hope this helps

regards
Mogens

RE: Excel Formatting

If you change the cell to this it will truncate the number to 1 pt
="Text"&INT(E45*10)/10&"% Text"

note
="Text"&(INT(E45*10)+5)/10&"% Text"
should round of the digit as well.

Hope this helps

Thanks

RE: Excel Formatting

(OP)
What I was hoping was that I was doing something wrong so that I could control the formatting from the referenced cell.  Since I can highlite and change the referenced cells all at once I was hoping there was a way to control it from there.  Guess we have to do it the brute force way.

Thanks

RE: Excel Formatting

You can always force the initial cell to be truncated but you then loose those extra digits that you dont see.

RE: Excel Formatting

Roger,
="Text"&Fixed(E45,1)&"% Text"

Don Coffman

RE: Excel Formatting

Just my five cents:
="Text "&TEXT(Q19,"0.00")&" Text"
Replace the "0.00" with any formatting code you like (see Custom Number Formats in the XL help)

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

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