On 3/22/2012 6:13 PM, Richard Kaye wrote: > 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.
Tried that but it takes the first 15 positions and makes the rest zeros, so I lose the string in the last 14 or 15 positions. (Field is database is V(33) but this row's value was about 29 in length.) -- 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.
