Insert Current Date

Question

Hello,

I recently acquired Office 2016 but im having a hard time with an old hotkey i used to have.

I cannot insert the current date ( 10/27/2015 ) into my cells . Every time i use control + shift + semicolon it only pastes the actual hour.  command + shift + semilcolon does the same thing.

Is this a general thing or just my macbook pro?

thank you

Answer 1

Same here. Does not work on my swedish keyboard. Used to work with excel 2011.

Answer 2

Same for me. I usually use an Italian keyboard setup, and it does not work. Switching to the US keyboard setup arranges everything. Looks like something needs to be fixed. Everything was working fine with Excel 2011 (and the old shortcuts).

Answer 3

As a workaround I have created the following macro and assigned to a user defined shortcut (alt-cmd-l in my case):

Sub InsertTodaysDate()

' Keyboard Shortcut: Option+Cmd+l

'

    ActiveCell.FormulaR1C1 = Date

End Sub

Answer 4

Same for me all previous versions of Excel is working, 2016 is not working. I had the same OS (El Capitan) when it was working in 2011 as I have now with 2016. I have made zero changes except installing Office so this is a Microsoft Bug (or feature depending on how you see it.) :D