Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Cambridgeshire, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cell with numbers and text (2003)

    Hello Everyone,

    I think I ask this before, but I have a cell that I need to use to calculate a total and I want to include a letter (e.i. (A) in subscipt to refer to a note). My question is how do I do that within a cell and still have it calculate the total needed. Example would be $500(A) in cell a1. Thanks.

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

    Re: cell with numbers and text (2003)

    Use a formula in the cell to calculate the total, for example =SUM(B3:B45)

    If the subscript is not essential, you can use a custom number format to display the result the way you want:
    - Select the cell with the formula.
    - Select Format | Cells...
    - Activate the Number tab.
    - Select the Custom category
    - Type <code>$0"(A)"</code> in the Type box.
    - Click OK

    If you do need the subscript, you cannot do this in a cell with a formula. Put the (A) in the cell next to the cell with the formula, and format it as subscript.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Cambridgeshire, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell with numbers and text (2003)

    Thanks Hans again. That works.

Posting Permissions

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