I just tried that a few days ago for an application that needed leading zeros. It did not work. You simply get an '003838 in excel, instead of 003838. The ' does not get treated as an excel escape modifier when comi ng from a csv file.
Dave -----Original Message----- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 10:58 AM To: CF-Talk Subject: RE: OT: excel Put a "'" in front of the text in the file... Excel will treat it as a string that way. > i don't want the user to have to change anything on the fly. i want ex ce l > to not apply its own formatting. > > -----Original Message----- > From: Alex [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 06, 2002 1:39 PM > To: CF-Talk > Subject: Re: OT: excel > > > set the column as text > > On Wed, 6 Mar 2002, Steven Dworman wrote: > > > How can I keep Excel from formatting columns when I open a .csv file? I > > have a serial number column that can be all numbers, or a combinantio n of > > numbers and text. When Excel sees a long string of numbers it format s it > in > > scientific notation. > > > > Thanks, > > > > Steven D Dworman > > --------------------------------------------------------- > > Web Consultant > > Systems Administrator > > > > ComSpec International - http://www.comspec-intnl.com > > phone: 248.647.8841 > > cell: 734.972.9676 > > --------------------------------------------------------- > > EMPOWER-XL ***Software for Higher Education*** > > http://www.empower-xl.com > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
