formuals in comments in excel

[u9946675]

Hi

I want to put the date in a cell comment in Excel 97, but if I type,
for example, =today() in the comment it just shows that text. Does
anyone know a way to do this?

Thank you

 

[Paul B]

have a look here for a way to do it,

http://www.contextures.com/xlcomments03.html#DateTime

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003