When I press "CTRL - ;" it prints the date in a cell but 1/7/2003. Is
there a way I can update my program so it prints the actual date?

=today()
will give you todays date, at all times


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519072

Check your computer date or if you have a macro that uses that shortcut

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




wrote in message
ups.com...
When I press "CTRL - ;" it prints the date in a cell but 1/7/2003. Is
there a way I can update my program so it prints the actual date?

that's really weird. My clock was set to the wrong time and date. I've
never experienced that even when my battery has run down to nothing so
I didn't bother to check. It was the correct date and time yesterday I
wonder what caused it to reset?

hmmmm it just slipped back again to Jan 07, 2003? is it possible I have
some kind of virus? what would be the appropriate newsgroup to help me
with an answer on this?

If you close excel, reset your windows time/date, then reboot, what do you see
as the time/date -- not in excel, but via windows date/time.

If the date/time is correct there, then maybe you have a bug in one of your
excel macros that changes the date.

Start excel and put
=now() in a cell
Do you get the correct date/time?

If no, close excel.
reset the date/time.
reopen excel in safe mode
Windows start button|run
excel /safe

And test out the =now() once more.

If that works, I'm gonna guess that you have a macro that should be using
dateserial(), but instead is using Date and is setting the date back a few
years.

If you find that it is excel that's causing the trouble, but you can't find the
problem...

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm

========
One the other hand, batteries do wear out.

Until you get a chance to order/install a new battery, you may want to put a
shortcut to a VBS script that can reset your time/date.

http://groups.google.com/groups?thre...%40tkmsftngp04

In fact, you could add this shortcut to your Windows Startup folder. (well, if
you're connected to the internet when you start up.)

WindowsXP has the ability to sync time/date built in.
Windows start button|settings|control panel|Data and Time Applet
Internet Time tab

But it looks like it only updates once a week (if you don't update more often
manually).


wrote:

hmmmm it just slipped back again to Jan 07, 2003? is it possible I have
some kind of virus? what would be the appropriate newsgroup to help me
with an answer on this?

--

Dave Peterson