Disable autoformat in Excel 2010
Excel assumes you have not applied a format if you use general, so it tries to find the best format for the data you entered. To disable this, go to File => Options => Advanced and uncheck the option for "Extend data range formats and formulas."
Otherwise, you can set column D to something like number, text or even a custom format, and Excel will stop changing the formatting of that column.