Help: System Date and Time w/Formula

[Batman77]

Hi Team,

Is there a way to capture the system date and time by way of formula without it updating each day? Rather than having to use the =Now() function and then copying and pasting it as a value.

Cheers

​

 

[Latchmaker]

Place this Macro in your PERSONAL Worksheet

Open your Macro Menu and select to view macros select the NOW macro and then select options where it says Keyboard Shortcut just hit SHIFT-D then you can just use Cntrl-Shift-D to insert hard code of system time.

Sub NOW()

' Keyboard Shortcut: Ctrl+Shift+D
'


ActiveCell.FormulaR1C1 = "=NOW()"
ActiveCell.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveCell.Select
End Sub

 

[Batman77]

Hi Latchmaker,

Appreciate the response as it works great!

Thank you

 

[MARK858]

or without vba...

press CTRL+;
press SPACE
press CTRL+SHIFT+;

 

[Batman77]

Thanks Mark - This is useful also to the cause