Actually you need

with range("J4")
.value = now()
.numberformat="MM/DD/YYYY"
end with

"Sam Wilson" wrote:


Worksheets("Open Red Tags").Range("J4")=format(now(),"MM/DD/YYYY")

"Mike K" wrote:

Oh Wise Ones,
We have a disposition file that records a date the
entry was made among other things. I would like to add the time to that
stamp. I know this is simple for you programmers but I need help with the
syntax.

Current code:

Worksheets("Open Red Tags").Range("J4") = Date

I would like to add the date AND time to J4, but preferably keep the
formatting to display only the date (M/D/YYYY) . Could someone please help?

Thanks,
Mike