Overactive text to date conversion in Excel 2004!
Does anyone know how to turn off or at least change the settings for when Excel will convert text into a date. It's ok when I type 1/2/04 and it converts it to a date, but when Excel converts 3/4, or even 3-4 into a date, it is just really annoying. It doesn't even have a little menu that pops up under the text to turn off this correction feature like Word does for its auto correct. Any help with fixing this "feature" would be great.
Comments
However it seems that once you have entered 3/4 when the cells are in general format (giving 4 March) it will not automatically revert them and you will need to re-enter any you have already done.
Hope this helps