PC Review


Reply
Thread Tools Rate Thread

How do I make DATE non-volatile?

 
 
MichaelRobert
Guest
Posts: n/a
 
      21st Jun 2008
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 With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      21st Jun 2008
"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 With Quote
 
MichaelRobert
Guest
Posts: n/a
 
      21st Jun 2008
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 With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      21st Jun 2008
It's non-volatile for me.

--
HTH

Bob

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

"MichaelRobert" <(E-Mail Removed)> wrote in message
newsC3F5204-B181-40BA-851E-(E-Mail Removed)...
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDF: How make volatile Lyle Microsoft Excel Discussion 3 27th Feb 2007 01:40 PM
Make only active sheet Volatile? Or other solutions? tskogstrom Microsoft Excel Programming 3 8th Jan 2007 08:59 AM
Make date change in excel to current date when opening daily? =?Utf-8?B?amFtaWU=?= Microsoft Excel Misc 3 1st Mar 2006 03:37 PM
Creating non-volatile Date Nigel Microsoft Excel Programming 4 25th Feb 2005 05:04 PM
How can I make the date field change automatically when I make a . =?Utf-8?B?TmdpbmEgMjg=?= Microsoft Access Database Table Design 6 15th Feb 2005 03:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:45 AM.