ExcelBanter - formulas in comments in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formulas in comments in excel (https://www.excelbanter.com/excel-discussion-misc-queries/116169-formulas-comments-excel.html)

u9946675

formulas in comments in excel

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

All times are GMT +1. The time now is 02:17 PM.