That's assuming you are the one who created / imported the data into Excel. However, I receive Excel files very frequently where the user who created it Has little knowledge of formatting cells.
So very often I am forced to import data with dropped trailing zeros. That and phone numbers being converted to E notation....Hate those. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:38 PM To: [email protected] Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. No.... when I tell Excel that a column is dollars, or time, it always leaves the trailing zero. What are you doing that makes it remove that? -----Original Message----- From: George Gallen <[email protected]> To: U2 Users List <[email protected]> Sent: Wed, May 8, 2013 9:36 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. They call it Excel! -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:31 PM To: [email protected] Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Haha yes, but again, the original request... If a client sent me "dollar" figures where 12.2 was supposed to mean 12.20 I would go like ... what kind of system do you run where 12.2 means 12.20 ? I'm assuming that a file you want to read into a Pick system, with embedded MM.MM dollars is coming from an outside source. I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. _______________________________________________ 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
