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
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
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
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
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
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
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.
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,
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
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
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:
11 matches
Mail list logo