Marie

One way is to use the +N function.

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

The text will show in the formula bar but not in the cell.

Gord Dibben Excel MVP


On Tue, 14 Sep 2004 14:13:04 -0700, "Marie"
wrote:

Hi

I am looking for a way to annotate a cell and have the annotation move with
the value in the cell if the rows are sorted.

This works well with comments, but I am looking for something more
transparent to the end user. Tried using named ranges for each cell, but
when I did the sort the name range did not move with the sort.

Thanks
Marie