On Mar 5, 4:22*am, Stewart Gordon wrote:
Philosophaie wrote:
*Sheets("Sheet1").Range("A1") = Format(Now, "mmm dd yyyy hh:mm:ss AMPM")

<snip top of upside-down reply

Why not simply

* *Sheets("Sheet1").Range("A1") = Now

?

Stewart.

"Sheets("Sheet1").Range("A1") = Now" should work fine. It should also
give it a custom default format of "m/d/yyyy h:mm".

Matt