TODAY() and NOW() being reflected as zero
 

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() and NOW() being reflected as zero
 

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



"Barb Reinhardt" wrote in message
...
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() and NOW() being reflected as zero
 

=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



"JLGWhiz" wrote:

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



"Barb Reinhardt" wrote in message
...
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() and NOW() being reflected as zero
 

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

"Barb Reinhardt" wrote in message
...
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() and NOW() being reflected as zero
 

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



Peter T wrote:

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

"Barb Reinhardt" wrote in message
...
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


--

Dave Peterson

TODAY() and NOW() being reflected as zero
 

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



"Dave Peterson" wrote:

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



Peter T wrote:

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

"Barb Reinhardt" wrote in message
...
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


--

Dave Peterson
.