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

Thread: Ignoring the remainder of a cell

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

    Default

    An alternative heading may be comments within a cell.

    I often like to "play" with large spreadsheets by quickly changing a few numbers here and there and observing the results of the calculations. Is there an equivalent to the ' (single quote) in VBA which tells Excel to ignore everything after the ' ? I want to do this WITHIN the Excel cell (not Insert a Comment).

    I'd like to be able to quickly edit a cell to add a new number but at the same time keeping the original number (as a comment which Excel ignores) in case I need to revert back later.

    Penfold

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Penfold

    There are "cell Comments" under Insert>Comment

    ...or if the cell has a formula you could use:

    =SUM(A1:A100)+N("Just a comment")


    Excel will see text within the N Function as zero



  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Australia
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Dave, I know about the Cell comments but I am looking mainly for a fast way of keeping an old number stashed in a comment while I enter a new number.

    eg original cell A1: 123.456
    cell A1 with new number: 456.789 "123.456"

    (where the bit in quotes is the commented bit - *IF* it can be done!)

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry Penfold I'm afraid not. The closest you would get is the N() Function I showed, but you would need to read this in the Formula bar and/or while the cell is in Edit mode (f2). Maybe you could 'Flag' all cells containing the N() function with different Font or Background color.

    There is also the 'pop-up' Input message within the Validation feature found under "Data", but again you would need to select the cell!






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
  •