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 =====================================================
