That is what I thought too -- the .csv is fine, just excel.
We did try the apostrophe, but they don't like it when it shows up in the file.. What
we may do is replace the 0 with the letter O --
Thanks for the help!
Tim P.
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 18, 2002 11:52 AM
Subject: RE: SOT : Leading 0's in csv file
> > I'm building a csv file and the data has a leading 0 in front
> > -- for example:
> > 0123,0456,0789 etc...
> >
> > When I bring it into excel, it shows as 123 , 456 , 789 etc.
> > Is there any way I can output the .csv so that it retains
> > that leading 0 when I bring it into excel? (My gut feeling is
> > no, but I thought that maybe someone else here has run into
> > that before)
>
> The problem isn't the CSV, but Excel TRYING to be friendly
>
> What you've got to do is force Excel into seeing it as text - try
> putting an apostrophe (') in front of the numbers
>
> Philip Arnold
> Technical Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> Switchboard: +44 (0)20 8680 8099
> Fax: +44 (0)20 8686 7911
>
> www.aspmedia.co.uk
> www.aspevents.net
>
> An ISO9001 registered company.
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
