Are you on an IE-only platform? If yes, you can try try sending an HTML table to Excel instead of a .csv. Excel will read in an HTML table and preserve formatting information so you can get really fancy if you want.
--- Nathan Shaw <[EMAIL PROTECTED]> wrote: > 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 ===== I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
