It appears 2002 is different than 2000 Most of my wording extends past the fields, but when I click on the field, the data still shows at the top. I will deal with it for a while, then post in a few weeks, maybe someone will have more knowledge of this problem, or I'll take the time to post it on one of those newsgroups. Thanks to all of you for your attempts for me. If anyone has any other ideas, please email privately [EMAIL PROTECTED] If I get a solution, I'll let everyone know. 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 ----- Original Message ----- From: "Keith Thompson" <[EMAIL PROTECTED]> > If you get the ####### indication in a cell, that means that the cell > size is too small to show the format that is selected. In Excel, you > should be able to select either Number and set the decimals to zero or > select Text and the number will now appear as text. One item about the > text mode is that the alignment will be to the right rather than the > left as it would be in a number formatted cell. > > Keith Thompson > > Jeff Dougherty wrote: > > > > 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 > > > > > From: "Ed" <[EMAIL PROTECTED]> > > > > > 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 =====================================================
