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

    Custom Text In Numerical Format (2000)

    Having a brain drain this AM: I know I have seen this before, but for the life of me, I can't find it. What I am trying to do is include text that I make up in a cell that also contains a value that I must use in another cell(s). Foir example, I would like to include the words "gallons of petro" in a cell where I would enter a number, so that it would read, say, "2 gallons of petro". But I need to be able to use the two in other calculations as well. I know it has something to do with the "&" sign, but I can't recall and I was unable to find it in a search.
    Thanks.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Custom Text In Numerical Format (2000)

    I believe you want to the concatenate function or simply =A1 & " " & B1 where A1 and B1 contain the number and text
    Jerry

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

    Re: Custom Text In Numerical Format (2000)

    Jezza,
    Thanks for your reply, and although it will probably work, I am looking for a solution that doesn't utilize the concatenate function.
    Thanks.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Custom Text In Numerical Format (2000)

    Then use the second part of my suggestion

    "simply =A1 & " " & B1 where A1 and B1 contain the number and text"
    Jerry

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

    Re: Custom Text In Numerical Format (2000)

    You could use a custom format:
    - Select the cell or cells.
    - Select Format | Cells...
    - Activate the Number tab (if necessary).
    - Select Custom in the list of categories.
    - Enter the fiollowing in the Type box:
    <code>
    0" gallons of petro"
    </code>
    - Click OK.

    Since a number format only changes the display, not the underlying value, you can still use the numbers in calculations.

Posting Permissions

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