The solutions provided here should help: nospamNebula-RnD.com/blog/tech/2009/07/excel-csv1.html
> From: John Israel > ...Excel has the nasty habit of doing things to the > data. For example, leading zeros are removed from > numeric data. This is a bad thing if you have valid > data like 123, 0123 & 00123. Excel will make then all > 123. Sure, I can put quotes around them, but when the > folks that use macros and pivot tables, or tie into > other Excel files, these will not work ("00123" does > not equal 0123 in Excel). Big numbers, like GL#s get > converted to scientific notation. Some numbers or > text get converted to dates. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users