m] On
Behalf Of MB Software Solutions, LLC
Sent: Thursday, March 22, 2012 6:28 PM
To: profoxt...@leafe.com
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/col
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 Softwar
e.com
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 helpfull
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: ht
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
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 th
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,
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.
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 cel
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
10 matches
Mail list logo