Ed, This doesn't look right. I have number, but no 'custom' after I highlight that. I tried 'custom' general' and this turns digits into ########.
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: "Ed" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 12:06 AM Subject: Re: PCWorks: EXCEL 2002 problem > Jeff, > To enter a number as you illustrate 100401, do this > R-Click the top of the column > Select Format - Number - Custom - General > This will give you a raw number. > > Ed > > ----- Original Message ----- > From: "Jeff Dougherty" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, October 28, 2001 8:28 PM > 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 =====================================================
