Use special format for the cell/column and pick Zip Code from the list. Even though you are telling Excel it's text, it helpfully still tries to interpret digits as numeric.
-- rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Thursday, March 22, 2012 6:01 PM To: [email protected] Subject: [NF] Excel not displaying varchar(33) as true string but instead as "nnE+25" number 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 _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD0441D52934255@ACKBWDDQH1.artfact.local ** 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.
