Forum Discussion
Claudio Cantatore
Apr 27, 2017Copper Contributor
Shortcuts to insert current date and time ( CTRL + ; ) don't work in EXCEL 2013
Recently upgraded to Excel 2013 One of the most used (at least for me) shorcuts: 1) CTRL + ; to insert current date in a cell 2) CTRL + : to insert current time in a cell both do...
SergeiBaklan
Apr 27, 2017MVP
Hi Raffaele,
Please check this https://social.technet.microsoft.com/Forums/lync/en-US/dccd77b7-8faa-4dbb-95be-28f438123301/insert-current-date-ctrl-not-working-probably-in-excel-2013?forum=officeitpro, perhaps something what discussed will help.
osmanphus
Oct 26, 2020Copper Contributor
May I know if there any solution that in windows 10 + office 365 + Traditional Chinese keyboard? It seems only displaying ";" instead of ";".
- German_ChrisJul 13, 2021Iron ContributorEnglish WIN 10 + Excel 365 English + QWERTZ german
CTRL (STRG in german) + SHIFT + ;
works fine- Dietmar5Jul 13, 2021Copper Contributor
German_Chris Thank you for the answer. With me sometimes it works just fine but sometimes it does not.
I have but to say I am german, have a Ukrainian Laptop with (most probably russian) Windows set to english, (still always russian comments popping up, so I guess it is a russian windows they sold me) - english set Excel 365 and 3 languages permanently in use on an dual language qwerty english keyboard (especially with imprints for the ukrainian language) and using the Microsoft Keyboard Layout creator for adjusting some keys from russian use to ukrainian.
Now I am german, english speaking, living in Ukraine and learning ukrainian as 3rd language, that's still some challenge for the windows world. I do some french but that's nasty on that keyboard (you know these accontegraphs and güs and so 🙂 - that's difficult - especially in google translator, it is always asking the french keyboard. So if I do french all day I could adjust to but like this it is a bit nasty.
So, I am kind of a hardware software language pioneer trying to sort out my crosscultural language minutely changing computer system. Living just in the english world does not really have those problems. So I understand that the Microsoft guys have some problem with it.
Asking for my date in excel, sometimes it does with the : sometimes with the . sometimes it does not do it at all. So I am living with three kind of surprise options. Often now I type it in full because it is faster than to search and hope.