TODAY() and NOW() being reflected as zero

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

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