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 > ______________________________________________________________________ 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=coldfusiona 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
