Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Concatenate Values (Office 2000-2003)

    Hi Everyone,
    I am trying to concatenate the following: a cell with a formula that results in a total of 104.58; Another cell with a formula that results in 65.20. I would like to use concatenate to write these numbers as a ratio, rounding the numbers - as in 105:65. I can't seem to come up with the correct formula and I know it probably is placement of the parentheses: =concatenate(value(round(a1)+":"+value(b1)). Help please?

    TIA
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate Values (Office 2000-2003)

    Try:

    <code>
    =ROUND(A1,0)&":"&ROUND(B1,0)
    </code>
    Legare Coleman

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate Values (Office 2000-2003)

    Legare, that formula results in #VALUE!

    Thanks.
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate Values (Office 2000-2003)

    That says that one of the two values is a text string, not a number and therefore can not be rounded.
    Legare Coleman

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate Values (Office 2000-2003)

    Here is a strip-down version of the spreadsheet. See the highlighted cells starting in B44.
    Attached Files Attached Files
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Concatenate Values (Office 2000-2003)

    Excel doesn't like to concatenate number values. Try this:
    <code>
    =TEXT(B44,"0")&":"&TEXT(B48,"0")</code>

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate Values (Office 2000-2003)

    That did it - perfectly!!

    Thanks Hans!
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

Posting Permissions

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