Excel date/time

  • Thread starter Thread starter niskalsoham
  • Start date Start date
N

niskalsoham

I want to know how to enter current date and time(both, say exampl
08/01/2004 13:23) in selected cell.

I know that for current time ctrl+; and for current date ctrl+shift+;
but what about both date and time?

Thanks in advance
 
Niskal,

Paste this little macro (you can copy it right from here) into your
Personal.xls.

Sub PasteNow()
ActiveCell = Now
End Sub

You might want to assign it a shortcut key (Tools - Macro - Macros - Select
PasteNow - Options), like Shift-N, so you'd use Ctrl-Shift-N for a quick
paste any time. If you use Ctrl-N (without the Shift), you'll override the
shortcut for new workbook.
 
Back
Top