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 exce 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 combinantion of > > numbers and text. When Excel sees a long string of numbers it formats 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 > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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