Forum Discussion

Alberto Paolini's avatar
Alberto Paolini
Copper Contributor
May 28, 2017

a function not working (current date function)

Hi, when I try to add to my document of excel the current date (in a permanent way, so that it doesn't change every time I open Excel) I use the function: CTRL+SHIFT+;      The fact is that when I ...
excel
Formulas and Functions
Macros and VBA
office 365
Zachary Grotovsky's avatar
Zachary Grotovsky
Brass Contributor
May 30, 2017
Interesting, what happens when you use that shortcut?
Alberto Paolini's avatar
Alberto Paolini
Copper Contributor
May 30, 2017
The program seems to load something but then It happens nothing.
  • Yury Tokarev's avatar
    Yury Tokarev
    Iron Contributor
    May 31, 2017

    Hi Alberto,

     

    could you please let me know which keyboard language setting you are using? 

     

    Thanks

    Yury

    • Alberto Paolini's avatar
      Alberto Paolini
      Copper Contributor
      Jun 01, 2017
      i'm using the Italian language
      • Yury Tokarev's avatar
        Yury Tokarev
        Iron Contributor
        Jun 02, 2017

        Hi Alberto,

         

        Ctrl+; would not work for Italian keyboard. Could you pelase try CTRL+è instead? CTRL+SHIFT+è should be inserting time. Please let me know how it went.

         

        Thanks

        Yury

Resources