RE: [ExcelVBA] Formula from 2003 to 2010

 

Hi Sharon

Assuming the formula is not in E4, there has to be another cause.

My guess is that somehow the system clock is not running and is returning
zero to the Now(). Try putting =Now() in a blank cell and see what happens.
If that returns zero, start looking at the system. Open a command prompt
(Start/Run/Cmd) and type Time and press enter. It should return the current
time.

If that is the problem you could type Time and the time in the format
hh:mm:ss.00 this will set the clock You may also need to set the date in
the same way.

Then type exit to close the Command window and try the spreadsheet again.
If it gives the same time you typed in the internal clock is not running.

Beyond this it is difficult to troubleshoot without sitting in front of the
computer - I do not even know if you are running this on a thin client
connected to an IBM Mainframe, or an iPad or a normal PC.

Hope you can solve it.

Best Regards
David Grugeon
Excel VBA Group Moderator

-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of sheizageek
Sent: Saturday, 2 June 2012 2:47 AM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Formula from 2003 to 2010

The below formula worked great in an Excel 2003 file, but after converting
to 2010, the formula returns 1/0/00 0:00 instead of the Now() date and time.
I have formatted the cells for the proper format.

Typically, if data was entered into D4, then the timestamp would populate
into E4. If nothing was entered, the cell was blank.

Can anyone tell me how to fix this? I realize it isn't VBA, but thought
someone may be able to assist.

=IF(D4<>"",IF(E4="",NOW(),E4),"")

Thanks
Sharron

------------------------------------

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------Yahoo! Groups Links

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (6)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___