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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists