I use listQualify and enclose my values with double quotes and it keeps
leading zeros.
Stace
-Original Message-
From: John Venable [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 2:33 PM
To: CF-Talk
Subject: Re: SOT: showing leading zeros in CSV
Can't you set the c
>From his first Email: "Anyone out there have any nuggets of wisdom to do
this in excel?"
on 6/7/02 2:47 PM, Philip Arnold - ASP at [EMAIL PROTECTED] most eloquently
stated:
>> Can't you set the column properties to include leading
>> zeroes? I know you can in Access, I had to do it for
>> zip
> Can't you set the column properties to include leading
> zeroes? I know you can in Access, I had to do it for
> zip codes.
It's a CSV, a text file - how do you set column types in a text file?
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +
Can't you set the column properties to include leading zeroes? I know you
can in Access, I had to do it for zip codes.
John Venable
on 6/7/02 2:10 PM, BEN MORRIS at [EMAIL PROTECTED] most eloquently stated:
> List,
>
> I am looking for a way to show numeric values in a csv file preserving lea
If you're using the HTML2EXCEL tag (or going straight through the COM
object) to create your Excel file, there was a thread a few weeks back
where I ran into this.
Basically you have to use the Excel COM object to create the file and in
you output embed a non-printing character (CHR(3) was wha
List,
I am looking for a way to show numeric values in a csv file preserving leading zeros.
For instance, say someone's ssn is "005353828" I want it to show up that way instead
of "5353828". Anyone out there have any nuggets of wisdom to do this in excel?
In last field in the below example (i
6 matches
Mail list logo