Linda, I did all that several times and no go. I now get #### after I enter the field. Somehow I got some of the columns to do it, but they display a little triangle in the upper corner of the cell. This is supposed to signify an error in that cell. I guess this is different than yours..thanks for helping, Linda.
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]> To: <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 12:11 AM Subject: RE: PCWorks: EXCEL 2002 problem > Jeff....are you saying you did what I said and Excel is STILL trying to turn > your number into a date? > > I don't know why this is happening, since I told you to tell Excel it was a > number and NOT a date > > OK....I don't have or want 2002, but in 2000, if I select a whole column or > numbers and go to Format>Cells and click on the Number tab and select either > Number and NO decimal places or select General, the number remains a number > and NOT a date > > if this works differently in 2002, I don't know what to tell you.......did > you actually DO exactly what I said? and it still changes to a date?? > > 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: Sunday, October 28, 2001 11:28 PM > To: [EMAIL PROTECTED] > Subject: Re: PCWorks: EXCEL 2002 problem > > > Hi Linda, > I think you misunderstand me, or vice-versa. > In these programs, I want what I type to be displayed. I do not need > automatic decimal points, scientific numerals, etc. If I type 100401, this > is a model number, not a date which the programs tries to make a date..I > need this auto formatting turned off. > I believe I did some of the cells, by accident, then a small green triangle > shows up in the corner of the cell. > Can I turn of all special automatic formatting for these? > > 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 =====================================================
