Ignoring the remainder of a cell

Penfold · Mar 13th, 2002, 12:35 AM

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 · Mar 13th, 2002, 12:48 AM

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 · Mar 13th, 2002, 01:02 AM

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 · Mar 13th, 2002, 01:10 AM

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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 12:35 AM	#1
Penfold New Member Join Date: Mar 2002 Location: Australia Posts: 43	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

Mar 13th, 2002, 12:48 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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

Mar 13th, 2002, 01:02 AM	#3
Penfold New Member Join Date: Mar 2002 Location: Australia Posts: 43	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!)

Mar 13th, 2002, 01:10 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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!