I am going for lunch... but will continue playing after. http://139.142.208.132/test_2001/ExcelTest/
I see your woes ... Eric Dawson From: Nathan Shaw <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: cf excel formatting problem Date: Tue, 30 Oct 2001 05:06:32 -0800 (PST) This is all being done dynamically. Yes, if I bring it in manually into Excel, it is not a problem at all. What I need to know is: 1) how to tell Excel to treat the zip code as a text field OR 2) how to trick Excel into thinking the zip code is a text field. Nate ------------------------------------------------------- thinking aloud. 1) export / import as a text field 2) single quote at the front of the field How are you importing / exporting? Eric Dawson From: Nathan Shaw <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: cf to excel formatting problem Date: Mon, 29 Oct 2001 10:48:29 -0800 (PST) I am exporting some data to Excel and one of the fields is zip code. Excel is stripping all leading 0's (zeros) off of the zip codes. I need it to leave the zip code alone, i.e. treat it as text instead of a number. Any ideas anyone? So far, I have tried: 1) Using an obscure ASCII char in front of the zip. RESULT: Excel puts in a box when it encounters an ASCII char it does not understand 2) Enclosing the zip in both single quotes and double quotes. RESULT: Excel leaves the quotes in instead of treating them as a text qualifier 3) Looked at the Allaire forums, where I saw the same question asked but not answered. 4) Read up on Excel at cfcomet, but most things there are a little overkill for what I am trying to do. TIA, Nate ===== ---------------------------- Nathan Shaw Senior Web Applications Developer iaffect, Inc. http://www.iaffectonline.com ---------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
