date time =now() function

[Brenda]

I am trying to insert a date and time in a column to
indicate the date and time the information in a row is
being entered. I set up a macro to insert date and time
using the =now() function. The problem is that when I
enter a new date and time all of the date and times on the
page that were previously entered change to the new time.
I do not want the times to change. Can anyone help me
with this. Thanks.

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/datestamp.html

 

[JE McGimpsey]

Oops - wrong URL:

http://www.mcgimpsey.com/excel/timestamp.html

 

[R.VENKATARAMAN]

try using cntrl+;(semicolon) or control+shift+;
and fomat as you like

this I got recenlty from PC world

 

[Guest]

I had a similar problem and it was answered by Frank see
below, it may not be as simple as you think:-

Subject: Re: Static Date in Formula
From: "Frank Kabel" <[email protected]> Sent:
5/5/2004 12:15:15 PM

Hi
you need VBA for this. See
http://www.mcgimpsey.com/excel/timestamp.html

This will solve your problem

Eaon#

 

[David McRitchie]

you need VBA for this. See [insert date with event macro]

http://www.mcgimpsey.com/excel/timestamp.html

and if you have a hard time reading John's site because the font is
too small and Internet Explorer does not allow you to change
the fontsize you might open it with Mozilla which does allow
you to change fontsize. Of course you could use a bookmarklet
to regain control that many HTML editors take away by force.
http://www.mvps.org/dmcritchie/ie/bookmarklet.htm

 

[JE McGimpsey]

Yeah, I really wish WinIE would handle relative font sizes correctly
(MacIE handles increasing/decreasing the font size just fine, of
course), but I really don't want to invest the time writing alternate
CSS2 for an obnoxious disregard for what every other browser allows.

David - your URI returns 404.

 

[Dave Peterson]

Typo:
http://www.mvps.org/dmcritchie/ie/bookmarklets.htm
is ok.