Jamie, If this is to be text, make sure that the field has a ' in front of the field. That's how excel deals with numbers that need to be text.
Steve Durette ----- Original Message ----- From: "JAIME HOI" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 2:54 AM Subject: CFFILE WRITE TO EXCEL SHEET > hi > i got a question here. i am writing some data into an excel sheet using CFFILE tag. However when the data happen to be a string like 0040, the first 2 zeros will be removed automatically once its written to the excel sheet. Is there any way to disable this function? Any help will be greatly appreciated. > > > ********************************************************************** > 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. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ********************************************************************** > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
