I had the same problem with Excel 2007 when exporting records from Horizon for import into Koha--the barcodes field had numbers like 3.2975E+13. Here's what worked for me: Right click on the top of the column Select "format cells" Choose "number" Change "decimal places" to 0. Irrelevant to this problem but possibly useful: I also had to design a cataloging framework for our library. I exported the default framework to a CSV spreadsheet, but editing it in Excel 2007 wouldn't work--I had to edit it in OpenOffice.Org Calc before I could upload it back into a new framework. Hope this helps, Fred King kohauser@phred.us
Colleagues, Anybody who knows how to go around a CSV problem; where barcodes (and or some fields) downloaded as CSV report in Koha is automatically transformed into dates by the spreadsheet application (Using Ms Excel 2007).
See attached screenshot for example or download here: https://dl.dropboxusercontent.com/u/7725309/koha_csv.png
EVAN NJOROGE about.me/uhusiano **adlsn.org* "Facilitating access to African digital content" * _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha