Here is my issue:
I have exported about 2000 records from a database to manually clean up the dates attached to them. (It appears that someone exported these records before, then re-imported them without fixing the dates, so things like "January 1935" became Jan-35.) I am trying to fix this problem by changing the format to Text when I fix the dates in Excel, which allows me to change dates back to the way we want them to look, but to import the cleaned data back into the system, I have to first change the spreadsheet to a .csv file - which loses the formatting, and reverts the dates back to that Jan-35 format I'm trying to get rid of!
Can anyone help me with a workaround? I tried pasting the info as "values only" into a new spreadsheet and saving it as a .csv, but once again, the .csv can't save this info and the dates revert again.
I am running Excel 2010.
Thanks very much, Kristen