Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Numeric function and inserted text in same cell (2000)

    To anyone,
    I would like to be able to insert both (1) a numeric function (i. e., A1+A2) in another cell (say, B1), and also (2) text that would follow the result of the numeric operation, but would be contained in the same cell.
    Any clues?
    Thanks,
    Jeff

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numeric function and inserted text in same cell (2000)

    =A1+A2 & " And The Text that follows A1+A2"
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Numeric function and inserted text in same cell (2000)

    You could use<pre> =(A1 + A2 ) & "Text",</pre>

    where Text is the text you want included.

    However the formula result will bw text, and not numeric. If it is only for display purposes, and you require that cell value be a number, you can use the following custom number format :<pre> #,##0 "Text"</pre>

    again where Text is the text value you want to display.

    Andrew C

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Numeric function and inserted text in same cell (2000)

    As usual, I am having a problem. I attach a file where I want the numeric result to include a $ and 4 decimal places. I can't seem to find the custom format that does the trick!
    Thanks,
    Jeff
    Attached Files Attached Files

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numeric function and inserted text in same cell (2000)

    Just add the $ sign and number of Decimals you need

    "$"#,##0.0000 "Text"

    HTH

    Peter

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Numeric function and inserted text in same cell (2000)

    Just figured it out; Thanks. The trouble is when you insert the semi-colons (say for negative values), Excel seems to ingnore your directions!
    Jeff

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Numeric function and inserted text in same cell (2000)

    Thanks, Peter. See my most recent post above.

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Numeric function and inserted text in same cell (2000)

    Attached is your w/b.

    I applied the custom format

    _("$"* #,##0.0000_) " per Pound";_("$"* (#,##0.0000) " per Pound",

    though I am not sure it makes sense for negative values.

    Andrew C
    Attached Files Attached Files

Posting Permissions

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