Timestamp wrong year

  • Thread starter Thread starter Calvin
  • Start date Start date
C

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
 
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?
Click to expand...

Hi Calvin
what are you using now?. If you're using a macro you may post the code.
Frank
 
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
 
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
Click to expand...

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
 
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 *
 
Back
Top