The problem is, Excel actually stores it with the equals and quotes. At a glance, it looks good, but again, it can cause some grief with pivot tables and when bounced against other Excel worksheets that have "true" data.
John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: Monday, July 06, 2009 10:35 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel I like the = method, ="1234567890",="001234",="01234",="1234" Will cause the import to treat as literals....which might be a downside. > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Israel, John R. > Sent: Monday, July 06, 2009 10:15 AM > To: 'U2 Users List' > Subject: Re: [U2] Simple Export to Excel > > I agree completely. However, 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. > > Argh!!! is it talk like pirate day again already? > > John Israel > Sr. Programmer/Analyst > Dayton Superior Corporation > 721 Richard St. > Dayton, OH 45342 > 937-866-0711 x44380 George _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
