Ignoring the remainder of a cell

[Penfold]

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

 

[Dave Hawley]

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

 

[Penfold]

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!)

 

[Dave Hawley]

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!