cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

Comment
Comments
Schnittlauch
Steel Contributor
‎Jun 08 2021 01:37 AM
‎Jun 08 2021 01:37 AM

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

A1
Gold Contributor
‎Jun 09 2021 05:48 AM
‎Jun 09 2021 05:48 AM

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! 

Dylan Snodgrass
Community Manager
‎Jun 11 2021 10:57 AM
‎Jun 11 2021 10:57 AM
Status changed to: Closed
 
Similar Ideas
No similar ideas