Copy then paste specialvalues


Gord Dibben MS Excel MVP

On Thu, 4 Sep 2008 08:51:00 -0700, J wrote:

Im using the if and then formula, which the =now() formula is included
within. Once I save, I want the date and time to remain the same and not
change to the date I reopen the file.

Please advise. Thanks!