TODAY() and NOW() being reflected as zero

[Barb Reinhardt]

The formulas TODAY() and NOW() are being reflected as ZERO when I enter them
in a separate cell today. I'm betting it's related to a recent update, but
am wondering if others have seen it as well.

Thanks,

Barb Reinhardt

 

[JLGWhiz]

Hi Barb, the results described seem very unusual. How did you use the
function?

 

[Barb Reinhardt]

=TODAY()
=NOW()

both formatted as GENERAL.

I have some other formulas that check the dates and they were behaving
strangely, so I broke the formulas apart and found that this seems to be the
issue.

Barb Reinhardt

 

[Peter T]

What do you debug with this

With ActiveCell
..Clear
..Formula = "=NOW()"
Debug.Print .Formula, .Value, .Text, .NumberFormat
End With

If not as anticipated, close Excel and try again with a new workbook

Regards,
Peter T

 

[Dave Peterson]

And maybe trying it a second time with events disabled:

application.enableevents = false
With ActiveCell
.Clear
.Formula = "=NOW()"
Debug.Print .Formula, .Value, .Text, .NumberFormat
End With
application.enableevents = true

 

[Barb Reinhardt]

OK, I inadvertently posted this in the wrong group. When I enter either
=TODAY() or =NOW() in a cell on a worksheet, the result is 0, when formatted
as general. And of course, when I look at it now, it's working fine. I
have no idea what happened.

Thanks,

Barb Reinhardt