What's the quickest way to copy the current date and time to clipboard?

I want to paste the current date and time to a spreadsheet and I am using the NOW() function and copy from there and paste as string but there might be a faster way. There might be an excel solution but a windows solution would be nice too becaue the problem/need isn't really excel specific.

Step 1: Open Notepad
Step 2: Hit F5
Step 3: Ctrl+A (to select all) then Ctrl+C (to copy)

Using Excel, you can use following keyboard shortcuts

• ctrl+; enters the current date

• ctrl+: enters the current time

Edit _{cudo's to @phuclv for the missing requirement}

Using plain windows, you could use

• Win+Rcmd /c date/t | clip
• Win+Rcmd /c time /t | clip

To answer the question, it depends which part(s) you want.

If it is just to copy to the clipboard, an executed VBS file would do it.

If it is to put the value into an Excel worksheet, an all VBA solution would suffice. When doing that, I would add the value and then set the numeric format. If you actually wanted a string, it could be: [A1] = Format(date+time, "mm/dd/yyyy hh:mm AM/PM")