This question already has an answer here:
- How to disable Excel number autoformat 4 answers
I use MS Office 2010. While using Excel, whenever I type 1 A, 2 A, 3 A up to 12 A and move to next cell by hitting Tab or Enter key it automatically becomes 1:00 AM, 2:00 AM.....12:00 AM. This problem is not there when I type 13 A, it is only up to 12 A.
The same problem is there when I type 1 P, 2 P up to 12 P. It becomes 1:00 PM, 2:00 PM.......12:00 PM. There is no problem for numbers larger than 12.
Why this happens ? How can I stop this ?