I have already disabled autoformatting from the autocorrect menu of the proofing tab in Excel options. For whatever reason I keep experiencing this formatting change even after explicitly setting the format in a blank cell. My table contains four columns, A B C and D. A, B, and C are formatted as time and D should be formatted as general. What happens, however, is after entering times in A and B (the time in C is calculated) any data entered in D gets formatted as time. I can change it back to general after data entry, but even if I set the format of column D in subsequent blank rows it still gets changed to time format!
This behavior is new in Excel 2010 as I'm using the same sheet created in 2007. Any ideas?