Re: [ExcelVBA] Formula from 2003 to 2010

 

do you know anyone else running Excel 2010? does it work for them? I
would not expect such a simple formula to be changed by an upgrade

JB

On 1 June 2012 17:47, sheizageek <sheizageek@yahoo.com> wrote:
> 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
>
>
>

--

===========================
http://uk.linkedin.com/in/drjohnbullas

__._,_.___

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

Messages in this topic (2)

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

.

__,_._,___