RLP

Try this....

=2+3+n("my wage+bonus-4 weekly loan repayments")

You will see the text in the formula bar but not in the cell.

The cell will calculate to 5 as you wish.

Note: you can also use cell references as in

=A2*A1+N("my wage+bonus-4 weekly loan repayments")

You could alternatively use a cell Comment to display the text.


Gord Dibben Excel MVP


On Tue, 5 Jul 2005 11:20:02 -0700, RLP wrote:

I thought there use to be a way to put text/info/label next to a number in a
formula that would still let it calculate but just ignore the text? In other
words, just in a simple formula like 2+3, you could type text next to each
number and the cell would still say 5?
I'm working with XP right now and maybe that feature does not exist anymore?