ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Disabling Automatic Date Thing (https://www.excelbanter.com/excel-discussion-misc-queries/187002-disabling-automatic-date-thing.html)

Matt

Disabling Automatic Date Thing
 
When i type '5-10' for example, and then press enter or leave that box, the
'5-10' i typed automatically changes to '05-Oct'. It's really irritating and
it happens with others, such as '10-15', basically anything that looks like a
date.

How do I turn this off?

Gary''s Student

Disabling Automatic Date Thing
 
Format the cell to Text prior to typing.
--
Gary''s Student - gsnu200785


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com