Results 1 to 3 of 3

CONCATENATE & Percentages

This is a discussion on CONCATENATE & Percentages within the Excel Questions forums, part of the Question Forums category; Hi there, I wish to concatenate a integer and text in one cell. I wish to convert the integer into ...

  1. #1
    New Member
    Join Date
    Aug 2010
    Posts
    28

    Default CONCATENATE & Percentages

    Hi there,

    I wish to concatenate a integer and text in one cell.

    I wish to convert the integer into a percentage and round it down to 2 decimal places. Here is my current formula:

    =CONCATENATE(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100)," % and text")

    However, I am left with a number with 10+ decimal places, for example:

    332.54545454545

    Is there a rule I can apply within the brackets to remove these extra decimal places? Ideally I want to stick with concatenation, as it is very helpful for my project.

    I am using Office 2007, Windows XP.

  2. #2
    Board Regular
    Join Date
    Oct 2003
    Posts
    173

    Default Re: CONCATENATE & Percentages

    use
    Code:
    =CONCATENATE(round(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100),2)" % and text")

  3. #3
    New Member
    Join Date
    Aug 2010
    Posts
    28

    Default Re: CONCATENATE & Percentages

    Quote Originally Posted by MisterBates View Post
    use
    Code:
    =CONCATENATE(round(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100),2)" % and text")
    That works perfectly - thank you!

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com