> 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
