Timestamp wrong year

[Calvin]

OK Since my last post I have learned a fair deal about macros. Becaus
of my circular ref. which I ws using for auto time stamp, but I had
problem doing a few other things with the time cell, so Frank advise
that I turn it off. Well now when my cell populates, but it populate
the wrong date with a 1900 or a 1904 year. How do I fix this

 

[Frank Kabel]

OK Since my last post I have learned a fair deal about macros.
Because

of my circular ref. which I ws using for auto time stamp, but I had a
problem doing a few other things with the time cell, so Frank advised
that I turn it off. Well now when my cell populates, but it populates
the wrong date with a 1900 or a 1904 year. How do I fix this?

Hi Calvin
what are you using now?. If you're using a macro you may post the code.
Frank

 

[Calvin]

I learned how to use the record macro, I still fuzzy on how to use an
view the code, but I was able to turn off the circ. ref. and recorded
macro the entered the timestamp but with the wrong dat

 

[Frank Kabel]

I learned how to use the record macro, I still fuzzy on how to use
and

view the code, but I was able to turn off the circ. ref. and recorded
a macro the entered the timestamp but with the wrong date

Hi Calvin
you may have a look at this introductionary material
http://www.mvps.org/dmcritchie/excel/getstarted.htm

To view the code you can hilt ALT F11 to invoke the VBA editor. Or goto
'Tools - Macro - Macros' and edit your recorded macro
Try copying the code and pasting this to the NG

Frank

 

[A.W.J. Ales]

Calvin,

It sounds as if you invoke the "1904 time system"
"Normally" Excel counts from 1-1-1900 (day 1) onwards, but you can set it to
count from 1-1-1904 onward.

Tools / Option / Calculation / Uncheck 1904 date system

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *