Hi Boris:

Start with a new workbook, put 1 in cell A1 and format as I indicated.

The formatting holds the comment.

I think this is best (if you don't want Inserted comments) because the
comment is alway visible on the worksheet and the underlying value is not
changed. So if you want to use cell A1 in a math formula, the formula will
work.
--
Gary''s Student - gsnu200772


"BorisS" wrote:

would love to under more about what you mean with the third option. I was
remembering the first one, but am intrigued by what the "best" one you
suggest is, and how it works. not quite clear from the short note. plz
elaborate. Thx.
--
Boris


"Gary''s Student" wrote:

Here are three ways:

1. use the N() function:
=RANDBETWEEN(1,10)+N(" hello World")
the comment is there but appears only in the formula bar, not the cell

2. concatenate the comment:
=RANDBETWEEN(1,10) & " Hello World"
the comment is now visible in the cell, but the cell is now text rather than
numeric

3. BEST put the comment in the format
Format Cells... Number Custom General" Hello World"
--
Gary''s Student - gsnu200772


"BorisS" wrote:

I am certain there was once a way I put comments INTO cells. I am not
talking about the comment feature, but text that I can write in the line of
the cell's text, and have Excel ignore it. I am on '07 now, and think that
it used to be an "N" at the beginning of a line, but now that produces a
function. Anyone know what I'm referring to and how to accomplish it now?

--
Boris