Current Date Shortcut keys

[Scott Huish]

It used to be I could press CTRL-; and put the current date in the cell but in Excel 2010 when I do this I get an ellipsis … instead. Has anybody else had this problem and how do I fix it?

Thanks.

 

[snb_]

ctrl; suffices here

You can restore the original settings with:

Sub M_snb()
    Application.OnKey "^;"
End Sub

 

[Ragnar1211]

Is there any other software running that is overriding the use of CTRL-; ? Autohotkey script maybe?

CTRL and ; work for me to get the current date
CTRL Shift and ; still give me the current time

(Just helping you verify that Excel defaults have not changed)

 

[Scott Huish]

Ragnar1211. That was it. Thanks, that was driving me crazy.