You need to format the cell as text BEFORE you put the number in it....I just did it here and if I format it after I put the number in, it doesn't work, but if I do it BEFORE it does
Weird, but it works....I just did it Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jeff Dougherty Sent: Monday, September 02, 2002 1:41 PM To: PCWorks mailing list Subject: PCWorks: Office XP-Excell formatting Hello, I am still having trouble with this stupid Excel program. I am using the same template I have been using for some time, with minimal trouble. I can highlight all the cells, choose to make them all general or text..and this should work. I try to place "25E5 " in a cell, any cell, and it changes to 2500000 or 2.50E+06 I choose paste special, then choose text and I can not get it to keep 25E5 . I guess the best thing to do is move to MS Works database, but I would rather figure out how to decide if I want these special formulas or not (which I don't.) You folks have tried to help before, but nothing seems to work. Jeff Jeff Dougherty ============= 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 =====================================================
