Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How to annotate values in a cell?

    I'm trying to remember an Excel tip I learned years ago, and I'm drawing a blank. I think it is possible to enter a value or formula in a cell, enter some character such as a semi-colon and follow it by text. The text is displayed, but does not interfere with the usage of the value. Am I crazy? Or did/does such a capability exist.

    Since I'm simply trying to jog my memory, I am not interested in work-arounds such as comments or concatenation. Thanks for your help.
    ENA

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You can do this with number formatting.
    Format cells, number, custom and something like:
    0.000": =pi"

    to display pi as:
    3.142: =pi

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hmmm! That's new. Not what I had in mind, but nifty. I wonder if I'm remembering a Lotus 1-2-3 feature and not Excel at all. I may have holes in my head.
    Thanks.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If you want to annotate a cell, you can use comments or you can use the N function. Enter something like:
    =5 + N("This is a note")

    The cell will still have the value of 5, since N("text") = 0...

    Steve

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post
    I remember that. It was Lotus 1-2-3 and it was a semi-colon. It has always seemed to me like a useful capability, since it brings the explanation closer to the cell contents (as opposed to a comment). Particularly when the cell contains a formula. Not sure why Microsoft never incorporated it - or something similar.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    There are several things that XL never incorporated from Lotus123. Datalabels for charts from a range and the ability to format in a formula are my 2 main peeves. The datalabels can be done via a macro (and there is an addin to do it), but the 2nd, excel has no capability to do...

    Steve

  7. The Following User Says Thank You to sdckapr For This Useful Post:

    duncanphilpstate (2011-10-27)

  8. #7
    New Lounger
    Join Date
    Feb 2011
    Posts
    13
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Thanks to Steve (sdckapr) for the N function tip - I'd never heard of that one before.

  9. #8
    New Lounger
    Join Date
    Aug 2010
    Location
    Riverside, CA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Apostrophe is the secret...

    Use an apostrophe (') that will show the rest of your typing as text in the cell. For the two examples above '3.14=pi will show 3.14=pi in the cell and '=5 + N("This is a note") will show exactly that =5 + N("This is a note") - I know you don't want to show the function but it could be of use to show what is being calculated or anything else you want to display. Just remember, there is no calculating on the value presented as it is actually text.

  10. #9
    New Lounger
    Join Date
    Jul 2010
    Location
    Richardson, TX
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to annotate values in a cell?

    To annotate in Excel try this:

    =A3&"text"

Posting Permissions

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