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. Anonymous
    2015-10-28T21:18:41+00:00

    From

    Keyboard shortcuts in Excel 2016 for Mac

    https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd

    Enter the date

    CONTROL + SEMICOLON (;)

    Enter the time

    + SEMICOLON (;)

    Apply the date format with the day, month, and year

    CONTROL + SHIFT + #

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  2. Bob Jones AKA CyberTaz MVP 435.8K Reputation points
    2015-10-28T14:54:29+00:00

    Is your recollection based, perhaps, on experience with the Windows version of Excel?

    Current date: Press CTRL+SEMICOLON

    Current time: Press CTRL+SHIFT+ SEMICOLON

    Current date and time: Press CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  3. Anonymous
    2015-11-10T18:23:45+00:00

    The results I get seem to agree with the article "Keyboard shortcuts in Excel 2016 for Mac" at https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2015-10-28T12:41:55+00:00

    It's not a general thing or your Macbook Pro. I think it is your memory. The keyboard shortcut for inserting a date in a cell is, and always has been control-semicolon.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2015-10-28T15:46:15+00:00

    Mine used to work perfectly on excel 2011, but as soon as i tried 2016, the function only inserts the hour.

    What do you mean this is my memory?

    Control + semicolon does not work it only inserts hour

    commmand + semicolon does not work it only inserts hour.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments