W. Yan
Reputation: 59
How to let excel to not detect the date value I enter
Every time I enter the date format in the excel, it will automatically change the value I enter to date format, but I just want to keep what I enter.
For example, if I enter 11/21 in the excel, it will automatically convert to 21/Nov. But I really just want to have 11/21.
Upvotes: 0
Views: 31
Answers (1)
Related Questions
- Prevent Excel to format string as date
- Stop Excel Form Auto Convert Date Time To Number
- Prevent users from entering a date
- How to turn off automatic formatting to date in Excel
- How to restrict Input box input to date only
- Excel changing the date when pressing enter
- How always to force a specific date format in inserted cell?
- How can I enter a date into an excel cell with a double click but have it only effect empty cells
- Prevent date formatting in VBA?
- How to stop excel from changing data format to dates?