RE: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-23 Thread Richard Kaye
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

Re: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-23 Thread MB Software Solutions, LLC
On 3/22/2012 6:52 PM, Fred Taylor wrote: It does work with automation (load the .CSV into a cursor, _VFP.DataToClip(,,3), format the column into text, paste the data to the active sheet). Cool to know, but this file is too big for that. But thanks anyway! -- Mike Babcock, MCP MB Software

Re: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-23 Thread Michael Madigan
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

[NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-22 Thread MB Software Solutions, LLC
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

RE: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-22 Thread Richard Kaye
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: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of

Re: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-22 Thread Fred Taylor
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

Re: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-22 Thread MB Software Solutions, LLC
On 3/22/2012 6:16 PM, Fred Taylor wrote: You have to format the cell to text BEFORE you load the .CSV file. Wait...setting any formats BEFORE loading the CSV file? Won't the CSV load OVERWRITE whatever I have open? Ok, I tried itthat didn't work. I must be misunderstanding your tip.

Re: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-22 Thread MB Software Solutions, LLC
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,

Re: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-22 Thread Fred Taylor
Hmm, maybe that only works for automation. I rarely ever have to work with actual files directly in Excel. Fred On Thu, Mar 22, 2012 at 3:26 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 3/22/2012 6:16 PM, Fred Taylor wrote: You have to format the

Re: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-22 Thread Fred Taylor
It does work with automation (load the .CSV into a cursor, _VFP.DataToClip(,,3), format the column into text, paste the data to the active sheet). Fred On Thu, Mar 22, 2012 at 3:26 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 3/22/2012 6:16 PM, Fred

Re: [NF] Excel not displaying varchar(33) as true string but instead as nnE+25 number

2012-03-22 Thread Christof Wollenhaupt
Instead of creating a csv file, why don't you create an XMLSS file? http://foxpert.com/docs/excel.en.htm Christof ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: