View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How do I make DATE non-volatile?

It's non-volatile for me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MichaelRobert" wrote in message
...
Thanks for the speedy reply. I thought that I had tried that and the date
changed on me, but I am probably wrong :-) I'll try it. Thanks again.

Mike

"Gary''s Student" wrote:

"CTRL+;" should be non-volatile
--
Gary''s Student - gsnu200793


"MichaelRobert" wrote:

I want to insert today's date into a worksheet record, but having
inserted
it, I want it to remain at that date - the date of the creation of that
record.

Regardless of whether I use TODAY or "CTRL+;" I seem to end up with a
volatile date. How can I freeze the date? Make it non -volatile?

Many thanks.

Mike