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.