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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
