Frustrating. It's also frustrating when a client gives you a CSV file with dollar signs and commas in it. Shouldn't Excel not include dollar signs and commas when it converts it to a delimited file? So instead of bringing it into a database I first have to bring it into Excel, change the type from "currency" to "numeric" and then bring it in. I can't just do a replace on commas since it's delimited by commas
----- Original Message ----- From: Richard Kaye <[email protected]> To: "[email protected]" <[email protected]> Cc: Sent: Friday, March 23, 2012 7:03 AM Subject: RE: [NF] Excel not displaying varchar(33) as true string but instead as "nnE+25" number Hmm... That trick has worked for me with my cell phone bill where international numbers get turned in to scientific notation by Excel. Perhaps if you extend the masking out to the number of places required? The other trick that worked for me was editing the cell contents and putting a single quote at the beginning of the data but that's obviously not a programmatic solution. -- rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Thursday, March 22, 2012 6:28 PM To: [email protected] Subject: Re: [NF] Excel not displaying varchar(33) as true string but instead as "nnE+25" number 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 _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD0441D5293425B@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. _______________________________________________ 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.
