i don't want the user to have to change anything on the fly. i want excel 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
