Stop auto format date

Stop auto format date
0

Upvotes

Upvote

 Jun 08 2021
3 Comments (3 New)
Closed

Hi,

 

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"!

Comments
Frequent 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,
Schnittlauch

 

"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. :)

Super Contributor

https://techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat

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
 
Similar Ideas
No similar ideas