Stop auto format date

Stop auto format date



 Jun 08 2021
3 Comments (3 New)



some times/ often it`s very annoying that Excel automatically formats numbers->dates.

E.g. when you CANNOT enter some latitude or longitude coordinates, because Excel automatically changes the number and even overrides the "number" formatting, so you cannot enter a "." - because Excel deletes it.


Please, give the user an option to switch of this "feature"!

Steel Contributor

Hi @Tontaube ,


this is the Tech Community Ideas hub, pls only post here ideas about the Tech Community, not about any products :D


Best regards,


"First, No system is safe. Second, Aim for the impossible. Third no Backup, no Mercy" - Schnittlauch


My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved. :)

Gold Contributor

The Excel Community invites you there to start discussions ask for a solution.

Or send feedback directly to the Excel Team through the Windows Feedback Center!

Welcome to MTC! 

Community Manager
Status changed to: Closed