OK..Linda is correct, formatting a new workbook as text will work, but shows a little green diamond in the upper left corner. Formatting as 'general' does not, though it would seem it should as the instructions state no formatting. Now, I found my problem was from the get-go, even though I formatted this thing from the beginning, when I save as CSV then open this one, these values change. The values are converted when I open the new CSV file. If I change the extension of the CSV to TXT before I open it and check the values, they have not changed, so I came to the conclusion opening these up with note pad or Works database the values do not change. Using Excel to open CSV and the values do change. Only problem is, I can't use Works Database to open because there are too many records. In conclusion, I found a work around until I find time to use another program. I appreciate all the responses, so much. So many of you really had the gears turning on this thing for me and you guys are great. IF there are any suggestions now that I pin-pointed my problem, feel free to email me mailto:[EMAIL PROTECTED]?subject =Excel.
Jeff Intrepid Video & Electronics Be careful of your thoughts. 501 Luther Rd They may become your words Harrisburg, PA 17111 any moment. ----- Original Message ----- From: "Linda F. Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 07, 2002 3:57 PM Subject: RE: PCWorks: Re: Excell XP revisited, one more time Sorry to disagree, Betty. I am a MOUS certified instructor of all the Office programs and I have all the versions of Office installed here and if I format a cell as text BEFORE I enter 25E5, it DOES work on my machines...and on ALL versions. 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 [EMAIL PROTECTED] . I have just re-installed Excel on my computer, and it acts just exactly as Jeff has been describing. Formatting one cell as text and then entering a string of numbers with an embedded "E" does NOT work! Formatting the whole page as text doesn't work if you want to do any calculations based on what has been entered unless you very carefully convert all the desired cells back to numbers again. What does work however, is to enter the desired text string with a leading apostrophe. Apparently, there are different versions of Excel being used, and they are not all the same. Betty Strohm ============= 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 =====================================================
