?......if you open a blank Excel > sheet and manually type in one of these numbers, does Excel try to turn it > into a date?
YES it does... I type 10-01-2001, Excel makes it 10/01/01 I type 10-2001, Excel makes it Oct-01 after I press enter. This is Excel 2000 > cells....then go to the Edit Menu and choose Clear>Formats > Another odd one..This only works for the text that is already there. Then when I click clear-formats to change the date back, it does not go back to the original text. 9-2001 changed to Sep-01, click clear formats, instead of changing to 9-2001, it changes to 37135. The next cell will become a date again. Format cells will only take care of this. But when I open a file created in MSworks database in Excel, it will change all those fields without asking me. And I can not get the original data back which is why I need it to default to 'general' or 'text'. 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 ----- Original Message ----- From: "Linda Johnson" <[EMAIL PROTECTED]> > Jeff......I'm not sure why this "autoformatting" is happening.....it must be > something that's coming in with the file?......if you open a blank Excel > sheet and manually type in one of these numbers, does Excel try to turn it > into a date? what does the number look like? > > one thing you can do is, AFTER you bring the data in, click on the little > gray square in the upper left corner of your spreadsheet where the columns > and rows meet........between A and 1....this will select all of your > cells....then go to the Edit Menu and choose Clear>Formats > > Linda > Linda's Computer Stop > http://www.personal-computer-tutor.com/ > Editor, ABC ~ All 'Bout Computers > http://www.personal-computer-tutor.com/ABC.htm > Online Instructor, Eclectic Academy > http://www.eclecticacademy.com/index.htm > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Jeff Dougherty > Sent: Saturday, November 03, 2001 10:05 AM > To: PCWorks mailing list > Subject: PCWorks: More trouble with Excell formatting > > > 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 ============= 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 =====================================================
