hi,
is it possible to use =now() so it does not change the date on all previous entries to the current day?
Example
insert text into cell A2,and cell B2 has the =now() and returns 28/3/19
I reopen the file another day ( ie 3/4/19) and now find that the text I entered previously in cell A2...