You have to format the cell to text BEFORE you load the .CSV file. Fred
On Thu, Mar 22, 2012 at 3:01 PM, MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > 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 > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/CAJCBkspofzw=Negno7iaxz2-D=Q8H4O_vZ_R3_kzo=a7mpj...@mail.gmail.com ** 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.
