I think that if you select the entire sheet and format it as text, you can then drag and drop the CSV file into that page and should have the same formats as you have in the CSV file. Just click on the Far upper left of the page proper and it should highlight the entire sheet. Then go to Format and select the Text only option.
Keith Thompson Jeff Dougherty wrote: > > Good day, > Thanks to a lot of you, I do know how to format the cells for each new > program I do. > What I really need to know, is there a way to turn off this auto format as a > default. > I have WDB files that I save as CSV. > When I open these up in a text viewer all is fine. > If I click on the CSV, Excel opens, but the file will not. I get no table > view at all. > If I drag the CSV file into the blank portion of the Excel window it will > open, but the cells are 'auto-formatted to dates and other formulas it > recognizes. > I have a program that I import these to, but can only import with the commas > separating the fields > I need the default option in Excel to stop auto-formatting these fields. > I really hope I explained this enough. > Thank you. > Jeff > > mailto:[EMAIL PROTECTED] www.9-11-2001tragedy.com > Help those affected by the NY/PA tragedy: > The Red Cross needs is mobilizing a national blood drive and needs your > help. Please call 800-GIVE LIFE, to find out where in your area you can > donate blood. > FAX 1-413-280-0677 > Intrepid Video & Electronics > Harrisburg, PA 17111 > 717-909-8844 > www.intrepid-video.com www.tech-repair.net www.thetoolcaddy.com -- Keith Thompson, Worthington, OH Home Web Page: http://freepages.family.rootsweb.com/~kthompson/ Genealogy Web Page: http://freepages.genealogy.rootsweb.com/~kthompson I Didn't Climb to the Top of the Food Chain to Be a Vegetarian ============= PCWorks Mailing List ================= Don't see your post? Check our posting guidelines & make sure you've followed proper posting procedures, http://pcworkers.com/rules.htm Contact list owner <[EMAIL PROTECTED]> Unsubscribing and other changes: http://pcworkers.com =====================================================
