Forum Discussion

Copper Contributor

Aug 23, 2022

Excel

Hi there, A little help required on Cltr key error in Excel. Everytime I press Cltr key, excel automatically puts today's date in the cell due to which I am not able to copy or paste anything...

Platinum Contributor

Aug 23, 2022

Stop automatically changing numbers to dates

Copper Contributor

Aug 23, 2022

Even after changing them as text, the moment I try to copy it by using CLTR+C as soon as I press Cltr key, the date appears in the cell

NikolinoDE
Platinum Contributor
Aug 23, 2022
Puneet894
Maybe the regional settings are wrong, otherwise I can't imagine anything else at the moment.
Change the Windows regional settings to modify the appearance of some data types

If you are already in Safe Mode (as Mr. Hans Vogelaar recommended), you could also update and/or repair Excel.
- Puneet894
  Copper Contributor
  Aug 24, 2022
  NikolinoDE I recently moved from India to Dubai, could that have caused the issue? If so, could u advise what should be the correct regional settings. Thanks
  - NikolinoDE
    Platinum Contributor
    Aug 24, 2022
    Puneet894
    Click on this link for instructions for Settings.
    Change the Windows regional settings to modify the appearance of some data types
    
    for Dubei choice United Arab Emirates
HansVogelaar
MVP
Aug 23, 2022
Puneet894

Do you have any active add-ins in Excel? If so, try disabling them one by one to see if the problem goes away.
- Puneet894
  Copper Contributor
  Aug 23, 2022
  Hi, thanks for your reply. I just checked and there are no active application add-ins
  - HansVogelaar
    MVP
    Aug 23, 2022
    Puneet894
    
    Try the following:
    
    Quit Excel completely.
    
    Hold down the left Ctrl key when you start Excel again.
    
    You'll be asked whether you want to start Excel in safe mode.
    
    Answer Yes.
    
    Does the problem still occur?

Resources