Share via

Insert Current Date

Anonymous
2015-10-28T05:55:54+00:00

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

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

24 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2016-03-17T14:54:59+00:00

    Apple imposed a lot of requirements on Microsoft for Office 2016. This could be one of them.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-03-16T23:46:35+00:00

    Sorry to disagree with you, my problem started the minute I installed Office 2016. It worked on the same computer using Office 2011. And back then I were using 10.10. Now I'm on 10.11.

    Was this answer helpful?

    0 comments
  3. Bob Jones AKA CyberTaz MVP 435.8K Reputation points
    2016-03-16T21:54:03+00:00

    Just offering this up for consideration, not looking for an argument... nor is this aimed at you, personally :-)

    Has anyone considered that it may not be a Microsoft issue? It's been proven - even by those experiencing the problem - that the default keystrokes work as they should when using the US keyboard.

    Key mapping, however, is a function of the operating system. It appears that those experiencing the problem are using OS X 10.11.x & may not have had the problem using prior versions of OS X. Also, those using the same versions of Office on OS X 10.10.x don't seem to be having the problem. Is it possible that perhaps Apple should be taking some of the heat on this issue?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-03-14T14:18:48+00:00

    I have the same problem. Contacted MS support today but all they said was that I should try to do a complete reinstallation of my Office. *lol*

    I always (Office 2011 and earlier versions) used SHIFT + CMD + ; for insert date but as others discovered, it inserts time instead. Furthermore if I press;

     SHIFT + CMD + COLON it insert current time same goes for SHIFT + CTRL + SEMICOLON and SHIFT + CTRL + COLON.

    So I have 4 different keyboard shortcuts to insert TIME but non for DATE *lmao* 

    If I switch to US-Keyboard insert date is working, but if I switch to my local Swedish keyboard setting it's not working.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-01-20T10:37:51+00:00

    Since I have given up on Microsoft support to help me correct this Bug, I'm testing my fortune with Applescript / Automator.

    Create an Automator workflow, save it as an service and therefore can create a keyboard shortcut to it.

    So far I've only let the script copy current date to clipboard (formatted the way i like it).

    This is my script:

    on run

    set date_ to do shell script "date +%Y-%m-%d" as string

    set the clipboard to the date_

    end run

    Here is where I read about how to make the automator script as a service:

    https://discussions.apple.com/thread/5486139?tstart=0

    Was this answer helpful?

    0 comments