Question: I have a file (only one) with some columns with integer numbers. When I change and save file, those columns are automaticaly converted in dates. Does anyone knows how can i prevent this? Thank You!

Answer: 
you might want to check out a similar issue here:

<http://www.mrexcel.com/forum/excel-questions/637277-excel-converting-numbers-dates.html>

(the below suggestions might not be particularly relevant to this issue, but in general, they might help to resolve such a problem)

Selct the cells and go to `Format --> cells --> number` and select Text for the selection 

There's also a one-keystroke solution: type an apostrophe before entering or pasting a pair of numbers that Excel could mistake for a date and month. When you exit the cell, the apostrophe vanishes and the numbers stay numbers, formatted as text.

this is what `microsoft` says:
<http://office.microsoft.com/en-001/excel-help/stop-automatically-changing-numbers-to-dates-HA102809473.aspx>

also if you are pasting data from somewhere else

try `Paste Special`
I guess there is still no solutions to this problem. 

It happens in both my computers when inserting data from sql server 2008. 

Half of columns becomes dates..... and im supposed to give this to my accountant.. sucks

(Btw i know about the special paste to text, then convert to number... but it takes so much time)....