How do I make DATE non-volatile?
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 |
How do I make DATE non-volatile?
"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 |
How do I make DATE non-volatile?
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 |
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 |
All times are GMT +1. The time now is 12:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com