How do I make DATE non-volatile?

M

MichaelRobert

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
 
M

MichaelRobert

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
 
B

Bob Phillips

It's non-volatile for me.

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top