So I understand that the Microsoft guys have some problem with it.Īsking for my date in excel, sometimes it does with the : sometimes with the. Living just in the english world does not really have those problems. So, I am kind of a hardware software language pioneer trying to sort out my crosscultural language minutely changing computer system. So if I do french all day I could adjust to but like this it is a bit nasty. 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.
How to enter function to insert current date in excel windows#
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 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. With me sometimes it works just fine but sometimes it does not. So, sometimes, it can be useful to try a mentionned shortcut from the online help in both combinations (Shifted/Unshifted) depending from the keyboard you for the answer. But from an en_US keyboard layouts' perspective, Ctrl+Shift+# is correct. This is due to that # is on a german keyboard reachable without pressing the shift key. This does not work, I have to use Ctrl+#. An example: for applying a date format, the German Online Article mentions that I can use Ctrl+Shift+#. Therefore, the mentionned shortcuts (keystrokes) can lead to confusion and may be appear as incorrect. There is a note about this on the top of the article.
I already reported this to the MS localization team and they are going to check this.Īnother problem in the online help article for the shortcuts (at least for German) is, that the shortcuts always refer to an English US keyboard. So, in this case, it's for now an error in online help article regarding Ctrl+Semicolon.įor Excel 2016, there are some more errors in the Online Help Article for the German shortcuts, such as some Alt shortcuts, for example Alt+M which opens the Tell Me Box instead of the formulas tab. For inputting the current date in an empty cell, I can use Ctrl+Dot as known from previous versions. I have Excel 2016 in German and I am using a german keyboard.