Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Comments

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In Quatro pro you can add comments to a formula by typing a semicolon ( after the formula. Is such a feature available in Excel other than by using the add comment and defining its display properties under Tools-options ?

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No, there is no way.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Eh

    Chosts about me post has g g ggone.

    I did say not that i know commenst you can play with easy, and VBA them to really cool one.

    i hate the sqaure bos so i have little fluff blue sky and top white cloudes, ok its a fade but best i could do... select it right click on the boarder and edit profiles...

    nice..
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I feared as much, guess we'll have to wait forversion 2003

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    If its that painful attach a command button to trip the right click add comment etc...

    Assign to what ever is active cell. this i use so i avaoid boaring yellow boxes..


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you want the comment to show, you could make it all text. That way you have the results of the formula and the comment in the same cell.

    Example:
    =TEXT(A1+A2,"0") & " This is a comment"

  7. #7
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-16 15:10, Peter99 wrote:
    In Quatro pro you can add comments to a formula by typing a semicolon ( after the formula. Is such a feature available in Excel other than by using the add comment and defining its display properties under Tools-options ?
    yes you can sought of.

    Use the N function eg.

    =IF(D15>C15,"nono",1234)+N("this is a comment - testing one two three 123")



    Kind Regards,
    Ivan F Moala From the City of Sails

  8. #8
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Come on guys, that's cheating.

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    cheatinh Nar thats the note formula we all know about.. good call guys.. i use this as a tag... works well wrap text helps so i

    = xxxxxxx
    &
    CHAR(10) &
    &
    " " &
    N(whatever ....)
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    opps

    fell i forgot the " "

    = xxxxxxx
    &
    CHAR(10) &
    &
    " " &
    N("whatever ....")

    I must get excel back ASPA and throw XP Win out...

    Did you know in WinXP you assign new printer via explorer!

    i shake me head.....

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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