| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find volatile cells | Excel Worksheet Functions | |||
| INDEX - volatile or not? | Excel Worksheet Functions | |||
| formula result=Volatile | Excel Discussion (Misc queries) | |||
| VBE Geeks in Volatile Functions | Excel Worksheet Functions | |||
| why is the INDIRECT function volatile? | Excel Worksheet Functions | |||
Linear Mode
