Excel shortcut ctrl+; doesn't work it gives ellipsis

[LiebermanD]

the ctrl+; used to work for a date. The cytl+: stillworks to give a time. What has happened. I am using office 2019 and Win 10. It used to work.

[#2 · Accepted solution]

Hello @LiebermanD,

Perhaps the discussions from this thread will be helpful:

https://techcommunity.microsoft.com/t5/excel/shortcuts-to-insert-current-date-and-time-ctrl-don-t-wo...

[#3]

Your suggestion was excellent. Thanks. It solved my problem. The assistance is greatly appreciated. An "expert" played with my machine remotely for > 30 minutes and accomplished nothing. This resolved my issue in > 5 minutes.
Again thanks

[#4]

Happy to help! :)