We recently upgraded to Excel 2010 which has become a problem when opening CSV files.
When opening a CSV files with issn's that have three leading 0's, (0001-6349 Acta Obstetricia et Gynecologica Scandinavica) Excel automatically changes the format to a date jan-and then a number.  This one translates as jan-49. 

Does anyone know how to change options so it won't automatically change the text?

Hopefully, someone else on this list (Serial Specialists) has encountered this and has come up with a simple solution.

Thanks in advance!
Sharlene LaForge
California State University, Library
Long Beach, CA 90840
(562) 985-8188