Source is a CSV file. Excel 2007 SP3 So instead of "20100124571687740210012481234" as the CSV, the cell display says "2010E+27" or something like that. Not all rows, though, suffer this problem. Some, where an alpha character is found, display as it should in full expanded form.
I format the cell to Text, and it doesn't change the way it looks. Even in the cell formula area, it won't show the 33 character field. I checked the CSV--it's surrounded with parens. Ideas? Thanks, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
